Lead SQL Server DBA-

Elkriddge, MD Onsite Day 1

Contract

The Lead Application DBA's responsibilities will include:

• Provide technical expertise and support in the use of DBMS.
• Evaluate and recommend available DBMS products to support validated user requirements.
• Define file organization, indexing methods, and security procedures for specific user applications.
• Create and maintain database objects such as tables, views, index, constraints, etc. for data platforms and custom applications.
• Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensure that data integrity, security, and recoverability are built into the DBMS applications.
• Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
• Design and develop logical and physical database designs from application requirements.
• Design and implement automation using scripts and database functions.
• Design and implement replication and backups for mission critical/tier-1 applications.
• Design and implement automation using scripts, must be proficient in scripting.

Education:

Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.

Experience:

• At Least 12 years of experience in Database
• Must have experienced in CI/CD

• At least six (6) years of experience in administering on-prem/cloud based multiuser environments with expertise in planning, designing, building, and implementing complex database systems.
• Administrated databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment.
• Experienced with optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring. Experienced in scripting and database functions.
• Experience in testing database security and enterprise policy guidelines according to established best practices.
• Monitored and maintained the backups for database recoverability for all production databases.
• Must have experience working in the database domain with at least Eight (8) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 with a minimum of two (2) years of EDB PostgreSQL DB.