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
Didn't find what you're looking for? Search again!
Loading more jobs...