Senior SQL Server DBA & IT Leadership

Ommay Momena

Queens, NY, ***** 908-***-**** ***********@*****.***

Summary

Highly accomplished and results-driven IT Leader with 15+ years of extensive experience in SQL Server Database Administration across investment banking, media, pharmaceutical, and market research sectors. Proven expertise in managing complex SQL Server environments (2000-2022), with a strong focus on Azure Cloud database management, high availability (AlwaysOn, Replication), performance optimization, data migration, and robust security implementation (TDE, RBAC, CyberArk). Adept at leading cross-functional teams, driving process efficiencies, and delivering solutions-centric critical thinking to align with organizational vision and achieve winning outcomes. Recognized for optimizing database performance by up to 25%, ensuring 99.99% uptime for mission-critical systems, and automating key operations to enhance reliability and reduce manual effort. Technologies

Database Administration: SQL Server Database Administration (2000–2022), Database Installation & Configuration, SQL Server Upgrades & Patching, Database Monitoring, Capacity Planning, Database Maintenance, Production Support, VLDB Management

SQL Server Technologies: SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019, 2022, T-SQL, Stored Procedures, Query Optimization, Execution Plans, Index Tuning, Table Partitioning, SQL Profiler, Query Analyzer High Availability & Disaster Recovery: AlwaysOn Availability Groups, Replication, Database Mirroring, Windows Clustering, Failover Clustering, Backup & Recovery, Disaster Recovery Planning, High Availability Architecture Cloud

& Virtualization: Microsoft Azure Cloud, Azure SQL Database Management, VMware Virtualization, Cloud Migration, Infrastructure Support

ETL, BI & Reporting: SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), ETL Development, Data Migration, DTS Packages, Crystal Reports, SSAS (Familiarity). Performance Tuning & Monitoring: Performance Optimization, Query Performance Tuning, Deadlock Resolution, Server Health Monitoring, DBCC Checks, Index Optimization, Performance Monitor, SolarWinds, Spotlight, SCOM, IDERA

Security & Compliance: Transparent Data Encryption (TDE), CyberArk, SQL Logins, Roles & Permissions, Authentication Modes, Active Directory Security, Database Encryption, Security Management Scripting & Automation: PowerShell Scripting, Job Scheduling, Process Automation, Backup Automation, Monitoring Automation

Tools & Platforms: SQL Server Management Studio (SSMS), Visual Studio, ServiceNow, Citrix, Ivanti, Microsoft TFS, Data Tools, Microsoft Access

Operating Systems: Windows Server (NT, 2000, 2003, 2008, 2008 R2, 2012, 2012 R2, 2016) Soft Skills: Team Leadership, Cross-Functional Collaboration, Troubleshooting, Change Control Management, Process Improvement, Team Training & Mentoring.

Experience

Senior SQL Database Administrator State Street, Remote Mar 2025 – Present

• Manage and administer enterprise-scale SQL Server environments supporting mission-critical financial applications across production, QA, and development systems.

• Monitor and maintain 500+ SQL Server databases (SQL Server 2012–2022), ensuring high availability, performance optimization, and compliance with financial industry standards.

• Configure, maintain, and optimize AlwaysOn Availability Groups, Failover Clustering, Replication, and Disaster Recovery (DR) strategies to achieve maximum uptime and business continuity.

• Perform SQL Server upgrades, migrations, and patching activities with minimal downtime using side-by-side and in-place upgrade methodologies.

• Implement and manage Azure SQL Database and hybrid cloud infrastructure to improve scalability, system availability, and operational efficiency.

• Optimize database performance through query tuning, index optimization, execution plan analysis, DBCC checks, and deadlock resolution, improving response times for business-critical financial systems.

• Develop, deploy, and maintain SSIS packages for ETL processes and support reporting requirements using SSRS dashboards and reports for operational and compliance teams.

• Strengthen database security by implementing Transparent Data Encryption (TDE), SQL logins, role-based access control (RBAC), Active Directory integration, and CyberArk privileged access management.

• Automate database monitoring, backup validation, job scheduling, and health checks using PowerShell scripting and SQL Agent jobs, reducing manual intervention and improving system reliability.

• Collaborate with infrastructure, application, and cloud teams to troubleshoot production issues, perform root cause analysis, and ensure seamless system performance.

• Support regulatory compliance, audit readiness, and financial data governance through backup retention, disaster recovery testing, and database security best practices. Senior SQL Server Database Administrator Infosys Limited, Boston, MA Jul 2018 - Feb 2025

• Led forward-thinking production database administration for a large-scale SQL Server environment, managing over 1,000 databases across 50+ production and 40+ test/development servers.

• Managed and maintained Azure cloud databases, leveraging cloud-native features for enhanced scalability, availability, and cost efficiency.

• Successfully executed multiple SQL Server upgrades (2008 to 2012, 2014, 2016, 2019, 2022) via side-by-side and in-place methods, minimizing downtime to less than 5%.

• Engineered and deployed SSIS packages to facilitate high-volume data migration from diverse source systems, ensuring data integrity and efficient ETL processes.

• Developed and optimized interactive SSRS reports with parameters, filters, and expressions, enhancing data accessibility and insights for key stakeholders.

• Managed and optimized over 100 SSIS packages, stored procedures, and jobs; utilized server-side tracing to identify and resolve deadlocks and locking issues, improving application performance by 15%.

• Proactively maintained database health through daily DBCC consistency checks, defragmentation, and index tuning, resulting in a 20% reduction in performance bottlenecks.

• Designed and implemented robust disaster recovery plans and automated failsafe backup remediation modules, achieving 99.9% data recovery success rates.

• Implemented Transparent Data Encryption (TDE) for critical databases, enhancing data security and ensuring compliance with regulatory standards.

• Automated monitoring and reporting for critical SQL Server metrics (disk space, CPU, memory, SQL services), enabling proactive issue resolution and maintaining system uptime.

• Mentored and led high-performing infrastructure and production support teams, fostering a collaborative global environment for onshore/offshore models.

• Achieved 25% performance gains for a critical bank risk management system through daily index tuning and query rewrites.

• Strengthened database security by implementing SQL logins, roles, and authentication modes, aligning with enterprise security policies.

SQL Server Database Administrator Montclair State University, Montclair, NJ Mar 2015 - May 2018

• Managed database administration for an SQL Server environment supporting 200+ databases across 40+ production and 50+ development/test servers.

• Configured and managed AlwaysOn Availability Groups across multi-subnet failover networks, ensuring 99.99% database uptime and high availability.

• Collaborated with Windows teams to configure and maintain Windows Failover Clusters, upholding Active-Passive and Active-Active environments using VMware.

• Implemented and managed Transactional and Peer-to-Peer Replication environments, ensuring data synchronization across distributed systems.

• Utilized Performance Monitor and SQL Profiler for query optimization and performance tuning, improving database server response times by 10-15%.

• Enhanced database performance and manageability through strategic implementation of table and index partitioning.

• Executed successful migration of databases from SQL Server 2012 to SQL Server 2014, ensuring seamless transition and data integrity.

• Developed and tested comprehensive Backup Plans and Disaster Recovery strategies, significantly reducing potential data loss and recovery time.

• Installed and configured the latest Service Packs and Hot Fixes on SQL 2008 R2, 2012, and 2014 servers, maintaining system security and stability.

• Designed and deployed SQL Server Integration Services (SSIS) packages to extract data from OLTP sources (MS SQL Server 2012, Text Files, Excel, and Access) to OLAP systems (SQL Server 2012). SQL Server Database Administrator City of Rochester, Rochester, NY Mar 2013 - Jan 2015

• Led SQL Server migration from SQL Server 2008 R2 to 2012, ensuring minimal downtime and seamless system transition.

• Configured and maintained AlwaysOn Availability Groups, including replicas, listeners, and disaster recovery solutions for high availability.

• Developed and managed SSRS reports to improve reporting, data accessibility, and business insights.

• Performed SQL performance tuning using execution plans, query optimization, and index tuning to resolve bottlenecks and improve efficiency.

• Implemented table/index partitioning and managed database security using SQL Logins, Roles, and Active Directory authentication.

• Designed and deployed SSIS packages for ETL workflows, incremental data loading, and error handling.

• Implemented database encryption and provided 24x7 production support, troubleshooting issues to maintain database performance and stability.

SQL Server Database Specialist Well Care Health Plans, Tampa, FL Jan 2011 - Jan 2013

• Provided expert administration, design, and performance analysis for very large (VLDB) and complex databases, ensuring optimal production support.

• Configured and maintained Active-Active/Active-Passive clustering in production and testing environments, applying hotfixes and service packs for continuous operation.

• Developed databases for production, development, and testing environments using SQL Server 2012 and 2008 R2.

• Transferred data from diverse source systems (Microsoft Excel, Access, flat files) to SQL Server using SSIS, ensuring data accuracy.

• Ensured database integrity and performance through regular DBCC checks, defragmentation, index tuning, and error log monitoring.

• Developed and automated disaster recovery plans and backup remediation modules, improving data resilience and reporting capabilities.

• Managed and troubleshot database mirroring in High-Performance and High-Availability modes, ensuring continuous data access and minimal downtime.

• Collaborated with development teams on performance enhancements and code reviews, providing input on index optimization, schema structures, and file layouts. Education

National University Bachelor of Arts in English Feb 2012 - Dec 2016 Certification

Microsoft Corporation Microsoft Certified Solutions Associate Microsoft Certified Azure Fundamentals

Microsoft Certified Professional

Compu21 Cisco Certified Design Associate

Compu21 Network+

Contact this candidate