One of our clients in the government domain is seeking an SQL Server Database Administrator with over 9 years of experience who will be responsible for overseeing and managing Microsoft SQL Server database environments, including those hosted on virtual machines (VMs). The DBA will focus on ensuring best practices in database design, configuration, performance tuning, and capacity planning to guarantee optimal reliability and performance of the SQL databases. In addition to technical responsibilities, the DBA will collaborate closely with the DBA ITM1 to achieve team objectives and meet performance metrics.
SQL Server Database Administrator
100% Remote
Long Term Contract
Responsibilities:
- Managing SQL Server database environments with a focus on scalability, performance, and security.
- Conducting capacity planning and ensuring proactive measures for future database growth.
- Implementing best practices for database configuration, backup, and disaster recovery solutions.
- Monitoring and optimizing database performance, addressing bottlenecks, and ensuring high availability.
- Collaborating with the IT team to align database infrastructure with organizational goals.
- Should be able to provide DBA support for distributed servers in a multi-datacenter environment.
- Monitor daily activities and performance of complex SQL environment, analyze technical problems, recommend adjustments, create, and implement 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 the network, IIS administrators, and storage groups for SQL server-based configurations.
- Develop technical documents, project plans, and tasks, and interact with customers for proposed solutions.
- Provide non-production and production support for deploying code and assist in troubleshooting 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, develop project plans with the project manager, or recommend approaches through defining tasks.
- Leading meetings relating to the design, implementation, operation, and ongoing maintenance of database 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 tuning cluster parameters for high performance, configuring standby servers.
- Configuring and implementing log shipping, configuring, and implementing 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 propose design and process improvements to achieve performance and cost optimization.
- Identify inefficiencies in current database designs and oversee the implementation of improved solutions.
- Plans and implements capacity and resource expansion to ensure the 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 supporting 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, and patching.
- Provides leadership and work guidance to less experienced personnel.
- Will also work with project management to support and ensure timely and effective client communications about deployments and upgrades.
Mandatory skills:
- Seeking an experienced SQL Server DBA with managing the MS SQL Server environments including the DB VM servers.