Senior Database Administrator (Digital Engineering Solutions)

Overview

Senior DBA leading cloud database design, security, performance, and CI/CD pipelines.

Key Responsibilities

• azure sql
• data governance
• disaster recovery
• schema design
• performance tuning
• security audits

Tasks

-Supporting Azure SQL, NO SQL, and other database needs for the project. -Implement data governance procedures and making sure that pertinent data regulations and standards are followed. -Develop and oversee a strategy for disaster recovery (DRM) to protect prevent data loss in the event of disasters or system failures. -Creating, implementing, and evaluating database-driven applications while following security and performance best practices. -Take ownership of the project and work independently in a collaborative environment. -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. -Engaged in the project workshops, collaborating with stakeholders and software developers to design the database schema and data models. -Collaborate with data analysts to provide them with well-structured data and insights needed for business intelligence and analytics. -Consistently monitors database performance and identifies bottlenecks that may impact the application's performance and responsiveness. -Manage and maintain databases, conduct routine maintenance tasks, and ensure data availability and integrity. -Conduct continuous R&D to provide the team with innovative database features, capabilities, and applications that will enhance the solutions. -Establish security measures for safeguarding private data, including encryption and access controls, and conduct routine database audits to find any possible vulnerabilities.

Requirements

• docker
• kubernetes
• azure devops
• sql server
• python
• dp-300

What You Bring

-Proficiency with container technologies, Docker, Kubernetes, Azure DevOps pipelines, CI/CD, and data pipelines in cloud environments. -Extensive and proven DBA expertise in large-scale SQL Server settings, including Azure managed instance databases. -Working knowledge of development IDEs (Visual Studio, Eclipse, etc.). -Knowledge of security regulations, such as Identity & Access Management (IAM), Customer Identity & Access Management (CIAM), and security authentication technologies. -Programming skills such as SQL, Python, PowerShell, and others to interact with databases and incorporate them into applications. -Strong understanding of database security best practices. -Working knowledge of microservices, monolith architecture, and web apps based on MVC, MVVM, and SPA. -Experience with Source controls systems (DevOps, GitHub, SVN, or TFS). -Exceptional analytical and problem-solving abilities, enabling the rapid identification of the root cause of a problem. -Experience managing data warehouses, data lakes, data bricks, and other cloud-based data storage solutions. -Knowledge with OWASP security principles, security compliance tools. -Proficiency in overseeing cloud-based data storage systems, including data warehouses, data lakes, and data bricks. -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 in creating best practice policies and procedures for data security and integrity, along with the monitoring and restriction of database access. -Bachelor’s degree in software development, Engineering, or related industry. -Azure certifications DP-300/DP-900 and accreditation preferred. -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. -Proficiency with SQL, Python, PowerShell scripting, or related technologies for creating application dashboards for proactive monitoring and authoring automation scripts. -Experience with the principles and practices of master-slave replication and database storage engines. -Knowledge of Azure cloud infrastructure and its capabilities. -Working Knowledge in Release management, and Bug tracking tools. -Proficient in delivering high- and low-level design (HLD and LLD) for projects, including ER diagrams, data models, and data pipeline flow. -Working knowledge of the Agile/Waterfall approach and how data pipeline fits into it. -Proficient in documenting, communicating, and coordinating, and capable of working efficiently under pressure.

People Also Searched For

About Cdm Smith

-It has evolved into a global leader in delivering engineering, environmental, and construction services. -The firm specializes in complex infrastructure projects that address environmental, energy, and water resource challenges. -With a wide range of capabilities, the company has delivered iconic projects in transportation, utilities, and industrial sectors. -The firm has a strong focus on providing sustainable solutions to tackle the most pressing infrastructure needs worldwide. -Its projects often involve advanced technologies and innovative design, particularly in water resources and environmental remediation. -The company’s work spans a diverse range of sectors, from heavy civil construction to energy, government, and transportation. -A standout project includes its involvement in critical infrastructure for water treatment and wastewater systems around the globe. -Known for its commitment to quality, the firm prides itself on turning complex challenges into successful, long-term solutions.

Sector Specialisms

Security Clearance

-may require criminal, employment, education, licensure, credit, and motor vehicle checks. -checks performed after a job offer (u.s.) or per local law for international candidates. -interviews precede any criminal background inquiry; criminal history does not automatically disqualify. -ongoing employment may require additional checks, including motor vehicle records and drug testing.