Sr. SQL Developer

  • icrunchdata Network
  • Plano, TX, USA
  • May 23, 2020
Information Technology (IT)

Job Description

Job Description About the Role The Sr. SQL Developer will lead the development of new AND the maintenanceoptimization of existing Ad-Hoc Queries, Stored Procedures, SQL Agent Jobs, Triggers, Indexes, Views and Functions. This role will also be responsible for installing, maintaining and configuring Microsoft SQL Server database instance with SQL Server Integration (SSIS) and Reporting Service (SSRS). Business Intelligence Development, Implementations, and Data Warehousing will also be key responsibilities in this role. A Day in the Life Performance Tuning and Query Optimization using native SQL Server tools Database backups and recovery, configure replication, db system planning Ensure performance, security, and availability of databases. Develop and maintain complex stored procedures Create documentation and UML diagrams for database processes. Handle common database server optimization tasks. Maintain Domo cards and optimized cards already in production. Maintain ETL processes and code. Create complex ad hoc queries Optimize database schemas, maintain database jobs, and dictionaries. Ability to fix issues related to database performance and provide corrective measures. Partner with stakeholders to create reports and dashboards for internal departments. Maintain and develop backend data layer code for internal applications. Maintain and optimize business intelligence environment (DOMO, COGNOS). What Sets You Apart Ability to troubleshoot issues with the databases and applications within our environment. Strong knowledge of data analytics and BI tools such as Domo or COGNOS is required. Must have strong critical thinking and problem-solving skills. Ability to communicate effectively. The ability to reverse engineer and re-write complex queries Education and Experience 10 years of experience as Microsoft SQL Server Developer. Database modeling, design, troubleshooting, error handling, and hardware planning Experience in Azure SQL Server, Salesforce, Netsuite is a plus but not mandatory Bachelor of Science in Computer Science, Mathematics, or a similar degree desired Thanks Regards, Amit Kumar TECH RBM Inc. 214-295-6596 Initiate. Implement. Innovate

Job ID