SQL Server DBA (SQL Server Database Administrator)

Position Summary

• Develop and maintain corporate SQL Server databases to ensure data integrity, security, retention, and recoverability.
• Design, build, test, and deploy database solutions aligned with project objectives and best practices.
• Administer enterprise-wide data architecture and implement complex data structures.
• Manage daily operations of corporate databases.
• Create and administer database objects to maximize availability, efficiency, and supportability.

Essential Job Functions

• Perform database administration tasks (installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup, and recovery).
• Provide 24x7 rotational on-call support, including Root Cause Analysis (RCA) and preventative actions.
• Manage change processes across development, test, QA, and production environments.
• Proactively monitor databases and resolve issues.
• Optimize databases and T-SQL (performance tuning, query optimization).
• Participate in projects involving database enhancements and design decisions.
• Implement database security policies aligned with corporate standards.
• Evaluate patch releases and manage deployment timelines.
• Support high availability (HA) and disaster recovery (DR) architectures.
• Maintain documentation on databases and data architecture.
• Support data management (ETL, archive, purge).
• Conduct capacity planning and generate weekly/monthly reports.
• Assist in project sizing, design reviews, and cost/resource estimates.
• Perform other duties as assigned.

Position Requirements

• 8+ years of SQL Server DBA experience.
• Expertise in SQL Server versions (2012 2016); knowledge of 2019 & 2022 upgrades.
• Experience with database backups, ETL, and archiving using native SQL tools.
• Proficient in diagnostic tools (DBCC, SQL Profiler, third-party tools).
• Knowledge of partitioning architecture.
• Experience with BI tools (SSIS, SSAS, SSRS, SharePoint).
• Strong T-SQL, PowerShell, and tuning/debugging skills.
• Familiarity with SQL Server Manager, Visual Studio, DTS/SSIS, Profiler.
• Experience with replication, mirroring, and HA/DR solutions.
• Ability to manage security/access for diverse user groups.
• Work well under pressure with tight deadlines.
• Self-motivated with strong prioritization skills.
• Adaptable to fast-paced environments.
• Excellent communication and teamwork skills.
• Strong organizational and analytical abilities.

Preferred Qualifications

• Microsoft Certified Database Administrator (MCDBA) or higher.
• Data modeling and metadata management experience.
• Knowledge of .NET applications or virtual environments.
• Oracle DBA experience is a plus.

Must Have

• 8+ years of hands-on SQL Server DBA experience.
• Expertise in backup/recovery, HA/DR, and performance tuning.
• Strong T-SQL, PowerShell, SSIS/SSRS skills.
• Experience with monitoring and optimization tools.
• Proficient in change management and patching.
• Knowledge of database security and access controls.
• 24x7 on-call support experience with RCA.
• Strong collaboration with development/infrastructure teams.

Skills

Access Control, Analysis Skills, Best Practices, Business Intelligence Software, Capacity Management, Change Management, Communication Skills, Corporate Policies, Corrective Action, Cost Estimates, Data Management, Data Modeling, Data Quality, Data Recovery, Data Structures, Data Transformation Services (DTS), Database Administration, Database Architecture, Database Backup, Database Design, Database Extract Transform and Load (ETL), Database Optimization, Debugging Skills, Disaster Recovery, Documentation, Establish Priorities, High Availability, Information/Data Security (InfoSec), MCDBA - Microsoft Certified Database Administrator, Metadata, Microsoft .NET, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft SharePoint, Microsoft Transact-SQL (T-SQL), Microsoft Visual Studio, On Call, Operations, Operations Management, Oracle DBA (Database Administrator), Organizational Skills, Performance Tuning/Optimization, Policy Implementation, Problem Solving Skills, Process Management, Production Systems, Project Design, Quality Assurance, Query Optimization, Replication and Remote Mirroring, Root Cause Analysis, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Security Monitoring, Software Patches, System Migration, Systems Administration/Management, Team Player, Test Plan/Schedule, Testing, Time Management, User Groups, Windows PowerShell

About the Company

Macpower Digital Assets Edge Private Limited