INSPYR Solutions
Lead Database Administrator
INSPYR Solutions, Fort Worth, Texas, United States, 76102
Title:
Lead Database Administrator Location:
Fort Worth Duration:
Contract Work Requirements:
US Citizen, GC Holders or Authorized to Work in the U.S. Pay Range: 45-50
Description
Lead and 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:
7+ years' experience in Database Operations with a Master's degree (Computer Science/ Informational Technology preferred). 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. About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.
Lead Database Administrator Location:
Fort Worth Duration:
Contract Work Requirements:
US Citizen, GC Holders or Authorized to Work in the U.S. Pay Range: 45-50
Description
Lead and 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:
7+ years' experience in Database Operations with a Master's degree (Computer Science/ Informational Technology preferred). 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. About INSPYR Solutions
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.