Senior SQL Server DBA

Job Description

Job Description

Initially remote.

This may change and candidate should also be ready to hybrid in the future.

• Should be able to provide DBA support for distributed servers in a multi-datacenter environment.
• Monitor daily activities and performance of complex SQL environment, analyzes technical problems, recommend adjustments, creates, and implements approved solutions using established tools and techniques.
• Provide technical assistance to the application development area and co-workers about SQL design and programming.
• Configures SQL services (e.g. security, JDBC, clusters). Plans, installs, and coordinates SQL Server releases, migrations, upgrades, and maintenance.

Build new environments as needed to support applications.

• Coordinating with the teams of network, IIS administrators and storage groups for SQL server-based configurations.
• Develop technical documents, project plans and tasks, interact with customers for proposed solutions.
• Provide non-production and production support for deploying code and assist in trouble shooting and resolving application issues.
• Support DevOps tools (Ansible, Jenkins, Nexis, Mavin, Bitbucket, Kony Mobile, Nginx etc.)
• Any other tasks assigned by the management team based on project / application needs.
• Provide technical Tier III support, develops project plans with project manager, or recommends approach through defining tasks.
• Leading meetings relating to design, implementation, operation, and ongoing maintenance of databases systems.
• Designs / plans of cluster nodes hardware selection and recommendations, configures / sets- up cluster nodes, sets-up interconnects, and configures cluster- aware storage;

installs cluster and database management system (DBMS) software on all nodes.

• Monitoring load balance and tunes cluster parameters for high performance, configuring standby servers.
• Configuring and implements log shipping, configures, and implements replication etc.
• Provide technical leadership that fosters database innovation and champions automation.
• Support strategic planning for database architecture, resource management, and capacity planning and growth.
• Ensures best practices in database planning, design, configuration, performance, and resilience.
• Evaluate and proposes design and process improvements to achieve performance and cost optimization.
• Identify inefficiencies in current database designs and oversees the implementation of improved solutions.
• Plans and implements capacity and resource expansion to ensure scalability of databases.
• Implements effective risk management controls and owns adherence to all compliance related items (exceptions, waivers, risks, technical compliance, and access control)
• Leads incident resolution efforts and engages appropriate resources to complete corrective actions as quickly as possible.
• Conducts research and provides recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Virtualized Infrastructure running various Unix, Linux, and AIX operating systems.
• Altering storage structures to meet the evolving needs of the Organization.
• Regularly updating the database security protocols, patching.
• Provides leadership and work guidance to less experienced personnel.
1 day ago