What are the responsibilities and job description for the Database Administrator - (Locals & W2 Only) position at Elegant Enterprise-Wide Solutions, Inc.?
About this Position:
Job Title: Database Administrator
Daily Duties / Responsibilities:
- Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while ensuring availability, scalability, performance, recoverability, reliability, and security.
- Acts as liaison for SQL Server database performance, integration, migration, upgrade, storage, and replication strategies.
- Performs SQL Server performance tuning: waits/Query Store analysis, index & stats optimization, SARGability fixes, and parallelism tuning.
- Monitors the database systems to ensure secure services with minimum downtime; configures alerts and telemetry for proactive detection.
- Interacts with project management and Agile development teams to develop a strong understanding of project and database development objectives.
- Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
- Documents, tracks, and escalates issues as appropriate.
- Participates in Scrum teams in support of Agile projects; end-to-end support for build, deployment, and operational activities.
- Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
- Performs routine operations and maintenance including installations, upgrades, patching, monitoring, auditing, and issue resolution.
- Manages and prioritizes multiple, diverse tasks simultaneously.
- Must be flexible, independent, and self-motivated.
- Works collaboratively to meet team goals/mission.
- Provides after-hours or weekend maintenance as needed.
Required Education:
- Bachelor's Degree.
Required Skills:
- 6 years of experience as a Database Administrator.
- 6 years of experience with Backup/Recovery.
- 6 years of experience with Performance Tuning.
Preferred Skills:
- Cloud Platform experience (SQL Database).
- PowerShell Scripting and Automation.
- Database planning, scaling, and capacity planning.
Note: For H-1B and OPT cases, we are seeking candidates from recognised organizations.
"No phone calls please."