Sr. SQL DBA Engineer

The primary purpose of this job is to provide Database Administration support for our client SQL Server enterprise systems, services and applications.

Responsibilities include, but are not limited to, SQL Server system High Availability design; standards-based implementation, security, systems integration, capacity planning, process procedure development, and performance tuning.

Essential Functions Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This is not intended to be an all-inclusive list of job duties and the position will perform other duties as assigned.

• 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 Base Line(Gold Image) and CIS benchmark Serve as a DBA Technical Lead and Subject Matter Expertise 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 operationmaintenance.
• 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 development and validation of Enterprise Business Continuity and Disaster Recovery plans. Maintain compliance to 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 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 also the current roadmap.
• SQL Servers version upgrades to latest version SSIS packages development and implementation New servers build as per Base Line(Gold Image) and CIS benchmark Capacity planning Disaster Recovery planning and execution DB Backup/recovery implementation Documentation Participates in DBA on-call 24X7 support in the event of system outage or failure.

Equivalent combination of education and experience is considered.

In lieu of a degree, 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.

• Strong written and verbal communication skills - ability to communicate effectively with all levels of audience.
• Strong interpersonal skills and ability to collaborate with team members.
• Effective time management, independent problem solving and multi-tasking skills.
• Must be able to present system design