SQL Server DBA

Company: MICASA GLOBAL
Location: Texas City
Posted on: March 17, 2023

Job Description:

Job Description

Job Description:
SQL Server DBA at Zensar takes up end to end ownerships of projects and provides valuable expertise in the project. You will do this by:

• Managing SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems.
• Configuring and maintaining database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Applying data modelling techniques to ensure the development and implementation support efforts meet integration and performance expectations
• Independently analysing, solving, and correcting issues in real-time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Assisting developers with complex query tuning and schema refinement.
• Providing 24x7 support for critical production systems.
• Performing scheduled maintenance and support release deployment activities after hours.
• Sharing domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. Database Project Activities like - MSSQL Database Installation, Build, Instance Creation, Database Object Creations Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configuring and maintaining database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
• Building/hardening SQL Servers
• Setting up, managing and supporting database backup, maintenance jobs and processes
• Database Server upgrades & migrations of medium and very large databases
• Experience in troubleshooting and resolving database integrity issues, migration issues, performance issues, replication issues, log shipping issues, connectivity etc.
  Skills required to contribute:
  
• A bachelor's degree in computer science or a related field with 10-12 years of experience in administrating SQL Server and other databases.
• Proficiency in DDL and DML including MS SQL.
• Analytical mindset and good problem-solving, troubleshooting skills.
• Up-to-date with trends and developments in database administration.
• Must be good with Performance tuning & query optimization techniques
• Good experience in Power Shell scripting,
• Configuration, setup and administration experience in High Availability (HA) and Disaster Recovery (DR) options for SQL Server as well as configurating Azure SQL databases in various options
• Strong interpersonal and team management.
• Excellent communication and presentation skills.
• Should be able to write low-level technical design documents with impacted areas.
• Working within a project management/agile delivery methodology in a leading role as part of a wider team.

Keywords: MICASA GLOBAL, Texas City , SQL Server DBA, IT / Software / Systems , Texas City, Texas