Sql Server Database Administrator

Srinivas Reddy

SQL Server Database Administrator

Phone: 717-***-**** Email: *********@*****.*** Status: Green Card

PROFESSIONAL SUMMARY

Highly experienced SQL Server Database Administrator with 16+ years in database administration, design, performance tuning, and support across MS SQL Server versions 2000 through 2022. Skilled in high availability, disaster recovery, cloud migrations (Azure), virtualization, replication, security hardening, and cross-platform data integration. Proven record of supporting large-scale, mission-critical environments in government, finance, healthcare, banking and enterprise sectors.

Ambition:

My goal is to grow into a senior data level where I can lead large-scale projects, optimize data pipelines, and contribute to building reliable systems. I aspire to continually improve my technical and leadership skills, while mentoring junior team members to help them succeed

TECHNICAL SKILLS

Databases: MS SQL Server 2022–2000, Azure SQL, postgres SQL, Mongo DB, Oracle 10g/11g, MySQL, Sybase ASE 15.0

Tools: SSMS, SSIS, SSRS, SSAS, Red-Gate, Idera, SQL Sentry, Erwin, Visio

Languages: T-SQL, PL/SQL, C, C++, VB6, .NET

OS: Windows Server 2022–2003, Windows 10/8/7, Linux

High Availability: Always On, Clustering, Log Shipping, Mirroring, Replication

Other: DTS, BCP, Bulk Insert, Data Partitioning, Security Auditing

Department of Children and Families, State of Connecticut – Hartford, CT

• Administered Microsoft SQL Server databases including installation, configuration, patching, and lifecycle management.

• Installed, configured, and maintained SQL 2008R2–2022 on Windows Server 2012–2022.

• Performed database performance tuning, indexing, query optimization, and troubleshooting for root cause analysis.

• Implemented and managed High Availability and Disaster Recovery (HA/DR) solutions including Always On, clustering, and log shipping.

• Supported database backup, recovery, and storage management strategies using native tools, RedGate, and Idera.

• Implemented Transparent Data Encryption, Dynamic Data Masking, and Row-Level Security to meet federal compliance and auditing requirements.

• Developed and enforced database security and auditing policies in compliance with state and federal standards.

• Managed medium to large production databases up to 5TB in size.

• Performed Cloud-based Azure SQL migrations, backups, and disaster recovery planning.

• Supported integration of SQL databases with enterprise applications, SharePoint, and analytics platforms.

• Worked with PostgreSQL 17.6 and 17 releases to develop code and query tables.

• Configured Always On Availability Groups, clustering, replication, and mirroring for high availability.

• Optimized performance via indexing strategies, statistics updates, and query tuning.

• Worked on MongoDB 8.0, 7.0, and 6.0 for handling large-scale data.

• Developed and deployed SSIS packages and SSRS reports for operational and analytical needs.

• Created and maintained technical documentation, SOPs, schema diagrams, and system configuration records.

• Worked on SQL Stored Procedures, functions, and triggers.

• Designed data models using Erwin and Visio.

• Support development and DevOps teams with Azure DevOps for deployment workflows.

ASSA ABLOY – New Haven, CT

SQL DBA Jan 2017 – Dec 2017

Leader in door security solutions serving commercial, retail, and government facilities.

• Installed SQL Server 2008R2–2016 in clustered environments; configured failover and active-active clusters.

• Executed database archiving and reload processes for multi-terabyte data warehouses.

• Optimized virtualized SQL Server performance through CPU/RAM tuning and degree of parallelism control.

• Implemented Transparent Data Encryption and Dynamic Data Masking for production servers.

• Automated maintenance tasks using PowerShell and SQL Agent jobs.

• Built and deployed SSAS cubes and SSRS reports to support business intelligence.

Providence Equity Partners – Providence, RI

SQL DBA Sep 2015 – Nov 2016

Global private equity investment firm specializing in media, communications, and education.

• Migrated SQL Server 2008/2008R2 to 2012 and 2014; applied service packs and cumulative updates.

• Deployed SQL Servers in VMware environments with optimized storage and resource allocation.

• Configured file growth management and index maintenance strategies to enhance performance.

• Implemented Always On Availability Groups, log shipping, and mirroring for high availability.

• Developed SSIS packages and SSRS reports; created SSAS cubes for advanced analytics.

• Automated administrative tasks with PowerShell scripts and job schedulers.

PointRoll – King of Prussia, PA

SQL DBA Mar 2015 – Aug 2015

Advertising technology company delivering dynamic, data-driven ad content.

• Upgraded SQL Server from 2005 to 2008R2 and 2012 in clustered environments.

• Optimized queries, indexes, and statistics for large-scale advertising data sets.

• Implemented partitioning and CTEs for performance on large transactional tables.

• Created and deployed SSIS ETL packages for data processing and integration.

• Ensured high availability through log shipping, mirroring, and Always On configurations.

Inspro Technologies – Eddystone, PA

SQL DBA Mar 2012 – Feb 2015

Insurance technology solutions provider for major carriers and administrators.

• Upgraded and maintained SQL Server 2005–2012 across development, QA, and production environments.

• Designed and optimized database schemas using Erwin and Visio; enforced indexing strategies.

• Configured Active/Passive and Active/Active clusters for mission-critical systems.

• Developed SSIS packages for ETL, SSRS reports, and SSAS cubes for analytical reporting.

• Conducted performance tuning and implemented security best practices including role-based access.

• Coordinated database migrations from Oracle, Access, and flat files into SQL Server.

AOPC, State of PA – Mechanicsburg, PA

SQL DBA / Developer Dec 2008 – Feb 2012

State government agency managing judicial systems data and services.

• Migrated legacy DB2 and Sybase data into SQL Server 2005–2008R2.

• Implemented database backup and recovery strategies for critical judicial data.

• Optimized large-scale databases via indexing, query tuning, and statistics management.

• Developed SSRS reports and SSAS cubes to support court analytics and decision-making.

• Automated weekly maintenance routines with SQL Agent Jobs and scripts.

Cardinal Health – Piscataway, NJ

SQL DBA / Developer Mar 2008 – Oct 2008

Global healthcare services and Products Company.

• Upgraded SQL Server from 2000 to 2005 and then to 2008 across clustered environments.

• Designed and implemented DTS and SSIS packages for data transformation and migration.

• Developed SSRS and Crystal Reports for operational and analytical reporting needs.

• Enhanced security through server-level and database-level triggers and permissions management.

• Optimized performance using Profiler, Index Tuning Wizard, and query refactoring.

EDUCATION & CERTIFICATIONS

Master’s, University of South Alabama, Mobile, AL – GPA: 3.82/4.0 (2005–2007)

Bachelor’s, JNTU, India – Graduated with Distinction (1998–2002)

WORK AUTHORIZATION

U.S. Permanent Resident (Green Card)

Contact this candidate