MS SQL and Azure SQL DBA IRC274874

Job Description Description Database Administration & Maintenance: Install, configure, and maintain MS SQL Server and Azure SQL databases. Perform regular database monitoring, health checks, and capacity planning. Ensure high availability (HA) and disaster recovery (DR) strategies are in place. Security & Compliance: Implement database security policies, user access controls, and role-based authentication. Ensure compliance with GDPR, HIPAA, and other regulatory standards. Monitor database audit logs for security breaches or unauthorized access. Backup & Recovery: Develop and test backup and recovery strategies using Full, Differential, and Transaction Log backups. Automate backup scheduling and test restore procedures. Automation & Scripting: Automate DBA tasks using PowerShell or any programming language Implement CI/CD pipelines for database deployments. Collaboration & Documentation: Work with application developers to optimize database performance. Maintain comprehensive documentation for database configurations and processes. Cloud Database Management (Azure SQL): Deploy and manage Azure SQL Database, Managed Instances, and SQL Server on Azure VMs. Configure Azure SQL geo-replication, failover groups, and backup strategies. Implement Azure Monitor, Log Analytics, and Automation for proactive issue detection. XML to JSON Good to Have: Performance Tuning & Optimization: Analyze and improve database performance using query tuning, indexing, and partitioning. Troubleshoot slow queries and optimize stored procedures. Implement best practices for SQL Server Profiler, Execution Plans, and DMVs. Python Requirements Database Administration & Maintenance: Install, configure, and maintain MS SQL Server and Azure SQL databases. Perform regular database monitoring, health checks, and capacity planning. Ensure high availability (HA) and disaster recovery (DR) strategies are in place. Security & Compliance: Implement database security policies, user access controls, and role-based authentication. Ensure compliance with GDPR, HIPAA, and other regulatory standards. Monitor database audit logs for security breaches or unauthorized access. Backup & Recovery: Develop and test backup and recovery strategies using Full, Differential, and Transaction Log backups. Automate backup scheduling and test restore procedures. Automation & Scripting: Automate DBA tasks using PowerShell or any programming language Implement CI/CD pipelines for database deployments. Collaboration & Documentation: Work with application developers to optimize database performance. Maintain comprehensive documentation for database configurations and processes. Cloud Database Management (Azure SQL): Deploy and manage Azure SQL Database, Managed Instances, and SQL Server on Azure VMs. Configure Azure SQL geo-replication, failover groups, and backup strategies. Implement Azure Monitor, Log Analytics, and Automation for proactive issue detection. XML to JSON Good to Have: Performance Tuning & Optimization: Analyze and improve database performance using query tuning, indexing, and partitioning. Troubleshoot slow queries and optimize stored procedures. Implement best practices for SQL Server Profiler, Execution Plans, and DMVs. Python Job responsibilities Database Administration & Maintenance: Install, configure, and maintain MS SQL Server and Azure SQL databases. Perform regular database monitoring, health checks, and capacity planning. Ensure high availability (HA) and disaster recovery (DR) strategies are in place. Security & Compliance: Implement database security policies, user access controls, and role-based authentication. Ensure compliance with GDPR, HIPAA, and other regulatory standards. Monitor database audit logs for security breaches or unauthorized access. Backup & Recovery: Develop and test backup and recovery strategies using Full, Differential, and Transaction Log backups. Automate backup scheduling and test restore procedures. Automation & Scripting: Automate DBA tasks using PowerShell or any programming language Implement CI/CD pipelines for database deployments. Collaboration & Documentation: Work with application developers to optimize database performance. Maintain comprehensive documentation for database configurations and processes. Cloud Database Management (Azure SQL): Deploy and manage Azure SQL Database, Managed Instances, and SQL Server on Azure VMs. Configure Azure SQL geo-replication, failover groups, and backup strategies. Implement Azure Monitor, Log Analytics, and Automation for proactive issue detection. XML to JSON Good to Have: Performance Tuning & Optimization: Analyze and improve database performance using query tuning, indexing, and partitioning. Troubleshoot slow queries and optimize stored procedures. Implement best practices for SQL Server Profiler, Execution Plans, and DMVs. Python What we offer Culture of caring. At GlobalLogic, we prioritize a culture of caring. Across every region and department, at every level, we consistently put people first. From day one, you'll experience an inclusive culture of acceptance and belonging, where you'll have the chance to build meaningful connections with collaborative teammates, supportive managers, and compassionate leaders. Learning and development. We are committed to your continuous learning and development. You'll learn and grow daily in an environment with many opportunities to try new things, sharpen your skills, and advance your career at GlobalLogic. With our Career Navigator tool as just one example, GlobalLogic offers a rich array of programs, training curricula, and hands-on opportunities to grow personally and professionally. Interesting & meaningful work. GlobalLogic is known for engineering impact for and with clients around the world. As part of our team, you'll have the chance to work on projects that matter. Each is a unique opportunity to engage your curiosity and creative problem-solving skills as you help clients reimagine what's possible and bring new solutions to market. In the process, you'll have the privilege of working on some of the most cutting-edge and impactful solutions shaping the world today. Balance and flexibility. We believe in the importance of balance and flexibility. With many functional career areas, roles, and work arrangements, you can explore ways of achieving the perfect balance between your work and life. Your life extends beyond the office, and we always do our best to help you integrate and balance the best of work and life, having fun along the way High-trust organization. We are a high-trust organization where integrity is key. By joining GlobalLogic, you're placing your trust in a safe, reliable, and ethical global company. Integrity and trust are a cornerstone of our value proposition to our employees and clients. You will find truthfulness, candor, and integrity in everything we do. About GlobalLogic GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world's largest and most forward-thinking companies. Since 2000, we've been at the forefront of the digital revolution helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.