Sr SQL Developer

Key Experience:

• 10+ years of SSRS, SSIS experience including experience as a SQL Server Architect/Developer/Administrator on large-scale (more than 50 tables) software development projects.
• 10+ years on a software development project that requires maintaining schema and data chances in a large-scale environment.
• 10+ years of experience in integration, initializing, populating, synchronizing, cleansing, mapping and transforming Bulk Data Migration on large scale projects with more than 50 million records.
• 10+ years in developing both OLTP and data warehousing data models (Kimball environment).
• Significant experience with writing and debugging stored procedures.
• 10+ years of experience in working with SQL Server 2019 CLUSTER Active/(Active/Passive) including database schema design, optimization, SQL Development, failover, XML, meta-data.
• Experienced designing a database cluster to handle more than one million OLTP transactions daily

Client JD: Sr. SQL Developer
Organizational Unit \ Accountability
Development Team, reports to Director of Development

Job Overview

Responsible for the design, development, implementation and deployment of applications as well as maintenance and reporting.

Responsibilities and Duties

1. Architecture and design of data models and database schemas based upon the requirements.
2. Develop and implement database administration and operational procedures.
3. Controlling access permissions, security and privileges for different users.
4. Implementing database clustering and ensure High Availability.
5. Creating, maintaining and optimizing database objects like indexes, triggers, views, stored procedures, catalogs, etc.
6. Optimizing the performance of SQL query and non-query commands.
7. Developing and implementing standards and procedures for database development, administration and deployment.
8. Installing, Deploying and Maintaining SQL Server database across different project environments like development, system testing, user acceptance testing and production.
9. Developing, managing and testing back-up and recovery plans.
10. Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly.
11. Capacity planning.
12. Fine tuning and optimizing database performance and throughput for High Volume OLTP applications.

Qualifications

• 10+ 10+ years of SSRS, SSIS experience including experience as a SQL Server Architect/Developer/Administrator on large-scale (more than 50 tables) software development projects.

·10+ years of experience in developing conceptual, logical and physical models through requirements gathering with developers and end users using common data modeling tools.

1. 10+ years on a software development project that requires maintaining schema and data chances in a large-scale environment.
2. 10+ years of performance tuning in a large-scale SQL database environment.
3. 10+ years of experience in integration, initializing, populating, synchronizing, cleansing, mapping and transforming Bulk Data Migration on large scale projects with more than 50 million records.
4. 10+ years in developing both OLTP and data warehousing data models (Kimball environment).
5. Significant experience with writing and debugging stored procedures.
6. 10+ years of experience in working with SQL Server 2019 CLUSTER Active/(Active/Passive) including database schema design, optimization, SQL Development, failover, XML, meta-data.
7. Experienced designing a database cluster to handle more than one million OLTP transactions daily.
8. Excellent communication skills and the ability to interact with Clients, Application Architects, Managers and Developers.
9. 2-3 years' experience as a DBA Administrator