MS Sql DBA

Primary Skills:

• MS SQL Server Administration: Production support, high availability configuration (AlwaysON), backups, recoveries, and security compliance.
• Database Design and Performance Tuning: Improving database design, indexes utilization, and queries performance tuning.
• Technical Leadership and Documentation: Serving as a DBA Technical Lead, developing and maintaining documentation, and ensuring delivery of assigned projects.

Secondary Skills:

• AWS Hosting and Migration: Participating in database design, new server build, upgrade, and migration to AWS hosting.
• SSIS Packages: Maintaining and deploying SSIS packages per business requirements.

Experience:

• In lieu of a degree, a combination of education and a minimum of ten (10) years of related work experience is required that provides the necessary skills and knowledge to perform all the essential job functions.

Role and Responsibilities

A. Key Responsibilities:

• Provide Database Administration production support for SQL Server Database business-critical systems.
• Production support of SQL Servers with AlwaysON in high availability configuration.
• New servers build as per BaseLine (Gold Image) and CIS benchmark.
• Serve as a DBA Technical Lead and Subject Matter Expert for Database projects, implementations, and tasks automation.
• Participate in application database design, new server build, upgrade, and migration to AWS hosting.
• Accountable for maintaining database backups and recoveries, and providing support for high availability systems in AlwaysON configuration.
• Work with developers and business users on improving database design, indexes utilization, and queries performance tuning.
• Develop and maintain proper documentation, including configuration specifics, and procedures for ongoing operation/maintenance.
• Accountable for security patching and cumulative upgrades of business-critical applications.
• Responsible for SQL Server Database stability, integrity, security compliance, and efficiency of the systems that support core functions of the business.
• Interact with senior engineers, management, vendors, and other stakeholders to identify areas of improvement.
• Maintain SSIS packages and perform deployments per business requirements.
• Accountable for ensuring delivery of all assigned projects and tasks, project implementation.
• Participate in the development and validation of Enterprise Business Continuity and Disaster Recovery plans.
• Maintain compliance with Security, Incident Management, and Change Management procedures.
• Maintain up-to-date knowledge of the IT industry as it relates to the technologies and processes in the Database domain, relevant organizational knowledge, and project management practices.
• Implement TDE, TLS 1.2, and maintain secure configuration and operation of SQL Server systems according to industry best practices.
• Participate in projects design discussions to ensure SQL Server Database designs are aligned with the Secure By Design philosophy, the  architecture, and the current roadmap.
• SQL Servers version upgrades to the latest version.
• SSIS packages development and implementation.
• New servers build as per BaseLine (Gold Image) and CIS benchmark.
• Capacity planning.
• Disaster Recovery planning and execution.
• DB Backup/recovery implementation.
• Documentation.
• Participate in DBA on-call 24X7 support in the event of system outage or failure.

B. Additional Responsibilities:

• Maintain compliance with all applicable federal, state, and local laws, regulations, and ordinances as well as policies, procedures, rules, and regulations applicable to the incumbent’s professional duties, responsibilities, and obligations.

Educational Qualification:

• Equivalent combination of education and experience is considered.

Certifications:

• Microsoft Certified: Database Administrator Associate