Senior Cloud Database Administrator -Virtual Drive- 10 Sep 26

CDM Smith; Pune District, Chennai District, Bengaluru; Hybrid; INR 1,800,000 - 3,200,000; Full time

Job summary

CDM Smith is hiring a Senior Database Administrator to join our Digital Engineering Solutions team in developing and deploying cloud-based solutions. The role focuses on CI/CD, data security, and scalable database architectures to support AEC initiatives.

The ideal candidate has extensive experience with Azure SQL, SQL Server, data governance, and cloud-native data pipelines, and will collaborate with development and operations to ensure robust data management and performance.

Qualifications

• Bachelor's degree in computer science or related field.
• At least 5 years of related DBA experience with SQL Server/Azure SQL.
• Experience implementing security, encryption, and access controls.
• Familiarity with regulatory frameworks and data governance.

Responsibilities

• Own projects and work independently within a collaborative environment.
• Design database schemas and data models with stakeholders.
• Implement security measures, encryption, and access controls; conduct audits.
• Monitor performance and identify bottlenecks.
• Develop disaster recovery strategies to prevent data loss.
• Establish data governance and regulatory compliance.
• Manage and maintain databases, ensure data availability and integrity.
• Collaborate with analysts to provide structured data for BI.
• Create and evaluate database-driven apps with security and performance best practices.
• Support Azure SQL, NoSQL, and other database needs.
• Use SQL, Python, PowerShell to interact with apps.

Skills

SQL Server

Azure SQL

Data security

CI/CD pipelines

Docker

Kubernetes

Azure DevOps

Database performance tuning

Data governance

Encryption

Education

Bachelor's degree

Azure DP-300

Azure DP-900

Software development degree

Tools

Azure SQL

SQL Server Management Studio

PowerShell

Python

GitHub

CI/CD tools

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.

Key responsibilities

• 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.

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.

Minimum Qualifications

• Bachelor's degree.
• 5 years of related experience.
• Equivalent additional directly related experience will be considered in lieu of a college degree.
• Preferred Qualification:
• Azure certifications DP-300/DP-900 a nd accreditation preferred.
• Bachelors degree in software development, Engineering, or related industry.