Database Administrator

Database Administrator

Location: Fort Worth, TX 76155 Duration: Contract 6+ Months - Possible Extension Schedule: Hybrid work schedule

Core Responsibilities:

• Database Management: The role involves managing and supporting high-volume transactional systems using databases like MS SQL Server, Postgres, and Azure SQL.
• Cloud Data Integration: You would work with Azure Synapse (a cloud-based analytics service) and Azure Data Factory (for data integration and ETL processes).
• Data Services: Leveraging Azure Analysis Services for data analysis and Microsoft Fabric (a set of integrated data management and analytics tools) to streamline workflows.
• Performance Optimization: Ensuring that the databases and systems perform optimally, even with large amounts of transactional data.

Job Description:

• Execute the cloud migration projects from On-prem Server to Azure, ensuring a smooth transition with minimal downtime.
• Implement best practices for database security and compliance with data privacy regulations, incorporating access controls, encryption, and auditing mechanisms.
• Proactively identify and resolve performance bottlenecks, working closely with development teams to optimize query performance, indexing strategies, and resource utilization.
• Implement and maintain robust monitoring solutions to provide real-time insights into database health, ensuring proactive issue resolution.
• Conduct regular health checks, capacity planning, and upgrade/migration activities to maintain system reliability and stability.
• Perform essential database administration tasks, including installation, configuration, monitoring, tuning, backup, recovery, and troubleshooting.
• Leading the architecture, design, development & testing processes and support of databases and other services on Azure
• Driving and supporting continuous improvement initiatives to enhance operational efficiency.
• Delivering high-quality, innovative and scalable technical solutions that make a tangible impact.
• Ensure 24x7 availability with on-call support for critical database systems hosted on premise and on multiple clouds.
• Design, Implement and maintain high availability and disaster recovery solutions.
• Driving automation by developing intuitive or simpler process designs.
• Collaborating with cross-functional teams and interacting with global stakeholders.
• Constant process improvement thinking to reduce delivery time and develop innovative solutions.

What you will need:

• Experience in Database Operations
• Highly experienced with database platforms (i.e. MS SQL Server, Azure Synapse, Postgres, Azure SQL) to support high volume OLTP systems.
• Robust knowledge of Azure Data Factory, Analysis Service and Microsoft Fabric
• Strong knowledge of data warehouse systems and MPP database architecture desired
• Experience in architecture design and managing Databases in cloud and on-prem.
• Hands on experience with SQL and DB performance tuning and rapid problem troubleshooting/resolution
• Understanding and ability to work with IaC, CI/CD Pipelines, Terraform, AWS CloudFormation, Aws Lambda, Azure Resource Manager etc.
• Skilled in scripting languages such as PowerShell, python.
• Good judgment, prompt decision-making ability, responsibility and accountability.
• Commitment to teamwork as a contributor.
• Ability to envision and create automation for provisioning and administration tasks.
• Document and maintain database policies, procedures, and standards.
• Relevant database/cloud certifications preferred