Senior Database Administrator (Digital Engineering Solutions)

CDM Smith; Chennai District; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

CDM Smith is seeking a Senior Database Administrator to join the Digital Engineering Solutions team in a hands-on role. The position involves designing and implementing cloud-based solutions, CI/CD pipelines, and ensuring collaboration between development and operations teams.

The candidate should bring extensive SQL Server experience, Azure SQL, and strong data governance capabilities. The role emphasizes security, scalability, and disaster recovery, with a focus on Azure cloud infrastructure

Qualifications

• Bachelor's degree; 5 years of related experience.
• Extensive DBA expertise in large-scale SQL Server and Azure SQL.
• Experience with data warehouses, data lakes and cloud-based data storage.
• Proficient in SQL, Python, and PowerShell scripting.
• Familiar with security best practices and data governance.
• Experience with Azure DevOps pipelines and CI/CD.

Responsibilities

• Take ownership of the project and work independently in a collaborative environment.
• Collaborate with stakeholders to design the database schemas and data models.
• Establish security measures for safeguarding private data, including encryption and access controls.
• Monitor database performance and optimize for scalability.
• Develop disaster recovery and data governance strategies.
• Ensure compliance with security regulations and data privacy standards.
• Support Azure SQL, NoSQL, and other database needs.
• Create dashboards and automation scripts for monitoring and analytics.
• Experience with data warehouses, data lakes, and data bricks.
• Knowledge of container technologies like Docker and Kubernetes in cloud environments.

Skills

SQL Server

Azure SQL

Python

PowerShell

Docker

Kubernetes

Azure DevOps

CI/CD

GitHub

Data governance

Security

Education

Bachelor's degree

Tools

Azure DevOps

GitHub

CI/CD tooling

Job description

Company Overview

Check out this video and find out why our team loves to work here!

Join Us! CDM Smith – where amazing career journeys unfold.

Imagine a place committed to offering an unmatched employee experience. Where you work on projects that are meaningful to you. Where you play an active part in shaping your career journey. Where your co‑workers are invested in you and your success. Where you are encouraged and supported to do your very best and given the tools and resources to do so. Where it’s a priority that the company takes good care of you and your family. Our employees are the heart of our company. As an employer of choice, our goal is to provide a challenging, progressive and inclusive work environment which fosters personal leadership, career growth and development for every employee. We value passionate individuals who challenge the norm, deliver world‑class solutions and bring diverse perspectives. Join our team, and together we will make a difference and change the world.

Job Description

CDM Smith is seeking a Senior Database Administrator to join our Digital Engineering Solutions team This individual will be part of the Development group within the Digital Engineering Solutions team, helping design and implementation of cloud‑based solutions facilitating CI/CD pipeline, and ensuring that software development and operations teams work collaboratively. An ideal candidate will be a critical thinker, proactive, and a highly interested in the application of new technologies and methods. This individual must showcase exceptional abilities in implementing solutions for AEC initiatives that involve cutting‑edge technologies. As a member of the Digital Engineering Solutions team, the Development group will be engaged in research and development and provide guidance and oversight to the AEC practices at CDM Smith, engaging in new product research, and the incubation of innovative ideas that arise from around the company. The ideal candidate should possess an extensive background in application development, that includes security, scaling, integration, and application migration, along with a commitment to continuous advancement and interest that drives measurable results.

• Take ownership of the project and work independently in a collaborative environment.
• Engaged in the project workshops, collaborating with stakeholders and software developers to design the database schema and data models.
• Establish security measures for safeguarding private data, including encryption and access controls, and conduct routine database audits to find any possible vulnerabilities.
• Consistently monitors database performance and identifies bottlenecks that may impact the application's performance and responsiveness.
• Develop and oversee a strategy for disaster recovery (DRM) to protect prevent data loss in the event of disasters or system failures.
• Implement data governance procedures and making sure that pertinent data regulations and standards are followed.
• Understanding the project's data security requirements, encryption techniques, and compliance regulations such as GDPR, CCPA, or HIPAA, and creating a strategy to support the project.
• Manage and maintain databases, conduct routine maintenance tasks, and ensure data availability and integrity.
• Collaborate with data analysts to provide them with well‑structured data and insights needed for business intelligence and analytics.
• Creating, implementing, and evaluating database‑driven applications while following security and performance best practices.
• Supporting Azure SQL, NO SQL, and other database needs for the project.
• Programming skills such as SQL, Python, PowerShell, and others to interact with databases and incorporate them into applications.
• Conduct continuous R&D to provide the team with innovative database features, capabilities, and applications that will enhance the solutions. Skills and Abilities:
• Extensive and proven DBA expertise in large‑scale SQL Server settings, including Azure managed instance databases.
• Proficient in delivering high‑and low‑level design (HLD and LLD) for projects, including ER diagrams, data models, and data pipeline flow.
• Proficient in the principles of database design, including managing of high‑volume instances of Azure SQL configurations that feature high availability, including the use of database performance optimization and monitoring tools.
• Exceptional analytical and problem‑solving abilities, enabling the rapid identification of the root cause of a problem.
• Proficiency in creating best practice policies and procedures for data security and integrity, along with the monitoring and restriction of database access.
• Experience managing data warehouses, data lakes, data bricks, and other cloud‑based data storage solutions.
• Experience in the Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) of disaster recovery are applied to the management of all database instance.
• Proficiency with SQL, Python, PowerShell scripting, or related technologies for creating application dashboards for proactive monitoring and authoring automation scripts.
• Proficiency in overseeing cloud‑based data storage systems, including data warehouses, data lakes, and data bricks.
• Experience with the principles and practices of master‑slave replication and database storage engines.
• Proficiency with container technologies, Docker, Kubernetes, Azure DevOps pipelines, CI/CD, and data pipelines in cloud environments.
• Strong understanding of database security best practices.
• Knowledge of Azure cloud infrastructure and its capabilities.
• Working knowledge of the Agile/Waterfall approach and how data pipeline fits into it.
• Working knowledge of microservices, monolith architecture, and web apps based on MVC, MVVM, and SPA.
• Knowledge of security regulations, such as Identity & Access Management (IAM), Customer Identity & Access Management (CIAM), and security authentication technologies.
• Working knowledge of development IDEs (Visual Studio, Eclipse, etc.).
• Experience with Source controls systems (DevOps, GitHub, SVN, or TFS).
• Working Knowledge in Release management, and Bug tracking tools.
• Knowledge with OWASP security principles, security compliance tools.
• Proficient in documenting, communicating, and coordinating, and capable of working efficiently under pressure.
• Passion to remain competitive in the market by enhancing abilities with cutting‑edge technologies.

Skills & Abilities

Excellent communication and analytical skills. Ability to work as a team player. Successful experience managing personal tasks to time and budget as a member of small teams. Proven excellent track record of managing priorities and resources. Possesses detailed knowledge of database systems and related infrastructure methodologies and technologies. Experience managing database systems, related technical stack and related process including performance management and operational control.

Qualifications

Bachelor's degree. 5 years of related experience. Domestic and/or international travel may be required. The frequency of travel is contingent on specific duties, responsibilities, and the essential functions of the position, which may vary depending on workload and project demands. Equivalent additional directly related experience will be considered in lieu of a degree.

Preferred Qualifications

• Azure certifications DP-300/DP-900 and accreditation preferred.
• Bachelor’s degree in software development, Engineering, or related industry.

Amount Of Travel Required

No Travel is required

Background Check and Drug Testing Information

CDM Smith Inc. and its divisions and subsidiaries (hereafter collectively referred to as “CDM Smith”) reserves the right to require background checks including criminal, employment, education, licensure, etc. as well as credit and motor vehicle when applicable for certain positions. In addition, CDM Smith may conduct drug testing for designated positions. Background checks are conducted after an offer of employment has been made in the United States. The timing of when background checks will be conducted on candidates for positions outside the United States will vary based on country statutory law but in no case, will the background check precede an interview. CDM Smith will conduct interviews of qualified individuals prior to requesting a criminal background check, and no job application submitted prior to such interview shall inquire into an applicant's criminal history. If this position is subject to a background check for any convictions related to its responsibilities and requirements, employment will be contingent upon successful completion of a background investigation including criminal history. Criminal history will not automatically disqualify a candidate. In addition, during employment individuals may be required by CDM Smith or a CDM Smith client to successfully complete additional background checks, including motor vehicle record as well as drug testing.

Additional Pay Range Information

CDM Smith is committed to fair and equitable compensation practices. This pay range is a good faith estimate representative of all experience levels for the geographic location assigned to the position. In addition to geographic location, a candidate’s salary is determined by several other factors including, but not limited to, the role, function and associated responsibilities, relevant work experience, skills, required certifications, and education/training.

Additional Compensation

All bonuses at CDM Smith are discretionary and may or may not apply to this position.

Visa Sponsorship Available

No - We are not open to sponsoring for this position

Agency Disclaimer

All vendors must have a signed CDM Smith Placement Agreement from the CDM Smith Talent Acquisition Manager to receive payment for your placement. Verbal or written commitments from any other member of the CDM Smith Inc. and its divisions and subsidiaries staff will not be considered binding terms. All unsolicited resumes sent to CDM Smith Inc. and its divisions and subsidiaries and any resume submitted to any employee outside of CDM Smith Talent Acquisition Team will be considered property of CDM Smith. CDM Smith Inc. and its divisions and subsidiaries will not be held liable to pay a placement fee.