SUMMARY

• Certified in SQL Server Database Administration, seeking a Database Administrator position with new challenges and opportunities to grow.
• Have hands - on experiences working on large and fast paced Enterprise environments, supporting MS SQL Servers in the areas of installation, configuration, administration, database migration, data modeling, maintenance, performance tuning, SQL patching, security, monitoring, implementing HA and DR solutions, Windows server vulnerability remediation, and business intelligence (such as SSIS and SSRS).
• A team player with excellent strategic planning, written, and verbal communication skills with proven ability to excel any task on hand.
• Eager to join a company with a dynamic culture that inspires its employees and fosters professional learning and growth.
• Strong knowledge and experiences with the new features of SQL Server 2019/2016/2014/2012/2008 R2/2008 includes configuring and administering High Availability Solutions like AlwaysOn, SQL Server Clustering, Database mirroring, Replication, Log shipping and maintenance of standalone and Clustered Servers Active/Active and Active/Passive Cluster Design
• Optimizing and Performance Tuning such as Query Optimization, Performance Tuning using execution plan, Profiler, Database Tuning adviser; Windows Performance Monitor tools to resolve Dead Locks or long running queries and slow running server
• Create and set-up Database maintenance plans, jobs for Database monitoring, maintenance, and automation
• Database migration from MS SQL Server 2008, 2008R2 to SQL Server 2012, 2014, 2016 to SQL Server 2019
• Deploying databases in Dev, Test, UAT, and Production environments
• Expert on Backup and Recovery including Point-In-Time and DR solutions with SLA, RPO and RTO
• Knowledgeable in Microsoft’s best practices with regards to configuration of SQL data/log, tempdb, backup location maintenance
• Applying Service Pack (SP) and patching hotfixes for SQL Server Database instances
• Creating and supporting database administration scripts and schedules using T-SQL
• Configuring and setup mail server for database mail notification
• Working on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers
• Installing and maintaining SQL Server Reporting Services SSRS 2008 and 2008 R2/2012
• Creating and scheduling SSIS/DTS packages
• Exporting and importing data from flat files like text, excel, and CSV to SQL Server
• Providing customer support to end-users on a day-to-day basis
• Providing on call DBA support 24/7 as needed

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, Business Intelligence Development Studio, Query Analyzer, SQL Profiler, SSIS, SSRS, Database Tuning Advisor and Index Tuning Wizard, SQLCMD, Upgrade Advisor, and SQL Configuration Manager

Databases: MS SQL Server 2019, 2017, 2016, 2014, 2012, and 2008R2

Languages: SQL, T-SQL, SQLCMD, and PowerShell

Operating Systems: Windows Server 2019/2016/2012/2008 R2/2008 Enterprise/Standard Edition, 2003 Enterprise/Standard Edition, Windows 2000 Advanced Server, Windows 7 and 10 Professional

Data Modeling Tools: MS SQL Server Database Diagram

Reporting Tools: MS SQL Server Reporting Services 2012, 2008R2

Ticketing Tools: Remedy, Jira, ServiceNow, Rally, and Zendesk

Development Methodologies: Agile

PROFESSIONAL EXPERIENCE

Confidential, Suitland, MD

SQL Database Administrator

Environment: MS SQL Server 2012, 2016, and 2019; Windows Server 2012, 2016, 2019; SolarWinds, Redgate, SSIS and SSRS

Responsibilities:

• Maintained critical Production databases including Emergency off-hour support
• Installed, managed, and administered SQL server 2012, 2016, 2019
• Implemented side by side migration of MS SQL server 2
• Applied Patches and Service packs to update different versions of MS SQL server
• Added nodes to existing clustered servers as part of data load/High Availability
• Configured Dev, Test and Prod databases in AlwaysOn Availability Group (AG)
• Maintained SQL clustering using SQL Server 2014/2016 with Synchronous Commit automatic-failover mode
• Maintained database security by creating logins with appropriate roles, users, and groups; granting and revoking privileges for data security
• Created and scheduled maintenance plans for updating statistics, checking fragmentation, checking database integrity, and backup plans
• Performed database backups and restored databases from backups
• Automated database tasks by creating jobs, alerts, and schedules for database maintenance
• Configured database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Used SQL Server profiler, Windows performance monitor and database engine tuning advisor to analyze and fine tuning of long/slow running queries and stored procedures
• Experienced in Migration from Redgate to SolarWinds monitoring tool
• Used SolarWinds tool for monitoring critical databases alerts
• Used Index Tuning Wizard to re-design and to create the indexes for better performance
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance
• Developed, deployed, and managed reports like ad hoc, parameterized, cascade, drill down and sub report in SSRS using multiple sources
• Developed SSIS packages to perform various ETL operations from/to various sources and destinations using SSDT, SSIS, Import/Export Wizard for SQL Server 2012/2016
• Worked on Windows Server security vulnerability remediation
• Configured mountpoint in Windows Server 2019
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Worked re-organizing and re-building Indexes based on the Index fragmentation
• Worked on data compression, fact table size reduction
• Conducted resource planning and coordination for application migrations with project managers, application, and web app teams
• Involved in capacity planning, sizing, and database growth projections
• Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices
• Provided on call support 24/7 as per team’s requirement
• Worked on creating and submitting CRQ and CPD

Confidential, Everett, WA

SQL Database Administrator

Environment: MS SQL Server 2008 R2, 2012, 2014, 2016, and 2019; Windows Server 2012, SSIS and SSRS

Responsibilities:

• Installed, configured, and maintained SQL Server 2014, 2016, 2019 on Dev, Test and Prod environments
• Upgraded SQL Server 2008 R2 instances and databases to 2014/2016
• Migrated SSIS packages from SQL Server 2008 R2 to 2014/2016
• Deployed Changes/SPs/Queries in Prod environment
• Configured and maintained SQL clustering using SQL Server 2014/2016 with Synchronous Commit automatic-failover mode
• Applied SP (Service Pack) and patching on SQL Server 2012, 2014, 2016 on a routine basis
• Worked on database refresh in Dev and Test servers with Prod data and reinstate the server
• Configured, managed, and monitored Mirroring, Log Shipping, and SQL clustering
• Implemented SQL Server security by creating and managing users, granting/revoking access
• Performed performance tuning for servers, databases, SQL/T-SQL queries and Stored Procedures
• Used Native Tools, Query Analyzer, Execution Plan, Live Query Statistics, Query Store, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, Resource Monitor and Activity Monitor for monitoring, tuning, and troubleshooting purposes
• Experienced in using DBCC commands to manage database consistency and repair as needed
• Used SQLCMD to create automated job for SQL Server Express edition
• Used PowerShell scripts to manage SQL databases and servers
• Used PowerShell to get AD groups, add SSMS Path variable, Ad user filter, Mount Disk management, to get ODBC drives, to find SQL instances and databases, to take backup SQL database into a remote drive etc.
• Used DMVs (Dynamic Management Views) and DMFs (Dynamic Management Functions) to monitor the health of a server instance, diagnose problems, and performance tuning
• Monitored server activities, error logs, space usage, database health, backup verification, cleaning histories, and solving problems as needed
• Performed regular database backups and restore databases as needed
• Installed, configured, and administered SQL Server Reporting Services (SSRS) and Report’s development, deployment, distribution, and reports subscriptions
• Developed, deployed, and managed reports like ad hoc, parameterized, cascade, drill down, and sub report in SSRS using multiple sources
• Developed SSIS packages to perform various ETL operations from/to various sources and destinations using SSDT, SSIS, Import/Export Wizard for SQL Server 2012/2014
• Extensively used SSIS transformations such as lookup, derived column, data conversion, aggregate, conditional split, execute SQL task and send mail task etc.
• Exported and imported data from flat files like text, excel, and CSV to SQL Server
• Applied patches and service packs to update different versions of MS SQL server
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Worked re-organizing or re-building indexes based on the index fragmentation
• Worked on database compression
• Involved in capacity planning, sizing, and database growth projections

Confidential, Alexandria, VA

SQL Database Administrator

Environment: MS SQL Server 2008, 2012, 2014, 2016, 2017; Windows Server 2012, 2008 R2 Enterprise Edition, Toad Data Modeler, SSIS, and SSRS

Responsibilities:

• Installed, Configured, and Administered SQL Server 2012, 2014 and 2017 in Dev, Test, and Prod environments
• Maintained database High Availability by installing, configuring, and managing Replication, AlwaysOn and Fail-Over cluster
• Assisted SQL developers to optimize SQL queries, stored procedures, and triggers
• Performed database monitoring and performance tuning
• Monitored servers’ activities and worked with clients to solve different problems
• Performed index and statistics management
• Managed SQL Server error logs, space usage, and growth pattern
• Migrated from on premises databases to Azure environment from SQL Server and maintain security
• Developed SSIS packages to perform various ETL operations from/to various sources and destinations using SSDT, SSIS, Import/Export Wizard for SQL Server 2012/2014
• Used DBCC to check database consistency, index fragmentation/rebuilding, and statistics; managed BLOCK and LOCK
• Performed database automation by creating backup jobs for different types of backups like FULL, Differential and Transaction Log
• Created jobs for database maintenance index fragmentation, rebuild, and database statistics
• Worked on different data modeling projects using ERWin for designing logical & physical databases
• Used backward and forward engineering to create logical and physical databases
• Created and managed indexes (Cluster/Non-Cluster) and Constraints
• Created and Managed users, group roles, schema at object level and performed data encryption
• Exported and imported data from flat files like text, excel, and CSV to SQL Server
• Migrated MS SQL 2008 to MS SQL Server 2012, MS SQL Server 2014, and MS SQL Server 2016
• Performed disaster recovery and re-built databases using backups