Sr. Database Administrator

Senior Database AdministratorECLARO is looking for a Senior Database Administrator for our client in New York, NY. ECLARO's client operates one of the world's largest energy delivery systems, constantly at the forefront of innovations in developing technology. If you're up to the challenge, then take a chance at this rewarding opportunity!Position Overview:The Senior Database Administrator is responsible for the administration, maintenance, performance, security, and availability of enterprise database platforms supporting critical business applications.The role works closely with application, infrastructure, and development teams to ensure reliable database operations, implement enhancements, troubleshoot production issues, and support strategic technology initiatives.Responsibilities:Administer and maintain Microsoft SQL Server databases supporting enterprise applications.Monitor database performance, availability, capacity, and storage utilization.Perform database backups, restorations, disaster recovery testing, and maintenance activities.Troubleshoot database performance issues, blocking, deadlocks, and data-related incidents.Implement database upgrades, migrations, and patching activities.Develop and optimize SQL queries, stored procedures, and database objects.Monitor and maintain production databases.Investigate and resolve incidents and performance alerts.Support application teams with database issues and deployments.Review database health metrics and capacity trends.Execute backups, recovery testing, and maintenance tasks.Participate in project meetings, migrations, upgrades, and operational improvementsRequired Qualifications:Strong experience with Microsoft SQL Server administration.Expertise in performance tuning, indexing, query optimization, and troubleshooting.Experience with database backup, recovery, replication, and high-availability technologies.Knowledge of database security, monitoring, and capacity planning.Experience supporting mission-critical enterprise applications.Strong analytical, problem-solving, and communication skills.Ability to work with cross-functional infrastructure, application, and business teams.Azure DevOpsBackup, Restore, and Recovery StrategiesDatabase Performance TuningIndex and Query OptimizationMicrosoft SQL Server 2016/2019/2022Monitoring and Alerting ToolsPower BI IntegrationPowerShell ScriptingPython ProgrammingSQL Server Always On Availability GroupsSQL Server Failover ClusteringSQL Server Management Studio (SSMS)SQL Server Security and AuditingSSIS and SSRST-SQL DevelopmentWindows Server AdministrationPreferred Qualifications:Database migration and modernization projects.Storage and infrastructure integration experience.Automation using PowerShell, T-SQL, or similar technologies.Azure Data FactoryAzure SQL DatabaseAzure SQL Managed InstanceData Warehousing ConceptsInfrastructure as CodeKubernetes and ContainersPay Rate: $75.00-$87.00/Hour If hired, you will enjoy the following ECLARO Benefits:401k Retirement Savings Plan administered by Merrill LynchCommuter Check Pretax Commuter BenefitsEligibility to purchase Medical, Dental & Vision Insurance through ECLAROEqual Opportunity Employer: ECLARO values diversity and does not discriminate based on Race, Color, Religion, Sex, Sexual Orientation, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status, in compliance with all applicable laws.