SUMMARY

• A Microsoft certified SQL Server DBA wif over 8 years of experience in Database Administration and overall IT industry and supported in Production, UAT and Development Environments in various business domains.
• Expertise in MSSQL Server Database Administration, installation, configuration, monitoring and maintenance, troubleshooting and finding RCA in both Cluster and Standalone environment
• Proficient in managing and administering VLDB’s in MS SQL Server 2019/ 2016/2014/2012/2008 R2/2005, MS Access, MySQL, Microsoft Azure Environments
• Work experience and knowledge wif High Availability (HA) solution in Virtualized and Data Center and Container Environments and worked wif feature like Always - On wif SQL Availability Groups, Database Mirroring, Native Replication and Attunity Replication
• Implemented Capacity Planning and Disaster Recovery (DR) solution, proficient in Database Backup and Restore, Point-in-Time Recovery in accordance wif RTO and RPO guidelines, extensively used SQL Agent Job based backup, third party tools like, TSM and TDPSQL, FlyWay, Veeam and ECX for Snapshot of VMs
• Database Performance Tuning and Optimization experience using SQL Server native feature like SQL Profiler, PerfMon, Execution Plan, Activity Monitor, Extended Events, Query Store, Database Tuning Advisor, DBCC utilities, DMVs and resolving slow performance and locking, blocking and deadlocking issues
• Experience in SQL Server routine maintenance, SQL Server Upgrades, SQL Server DB Migration and coordinating wif Server Team and Deployment Team for patch management, service packs updates, applying Hot Fixes using tools like SCCM, Habitat, uDeploy
• Automated SQL Server Health Monitoring using tools like SCOM, Splunk, Dynatrace, Tivoli monitoring
• Extensively worked wif SQL Server native features like Linked Server, SQLCMD, Temp Table, Triggers, Maintenance Plans, Database Mail notifications and Alerts, Database Encryption
• Proficient and knowledge in T-SQL, HTML, Power-Shell scripting and Comand-Line CMD
• Setting up SQL Server Security wif Minimal Privileged Access and Roles, users and permissions wif Active Directory and resolving Audit issues as per standards
• Experience and knowledge in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and ETL Processes using SSIS, BIDS/SSDT, BCP and Import/Export Wizard, uses of BI tools like QlickView, Attunity and Alteryx
• Extensively worked wif various ticketing system such as BMC Remedy, SMART IT, Request Center, JIRA, SCOM for day to day Change Request, Incident and Ticket generation and reporting
• Excellent Team player, detailed oriented, strong analytical and problem solving skills and managing VLDBs in OLAP and OLTP environments
• Provided 24X7 On-Call supports on a rotational basis to Production servers and used On-Calls scheduling tools like Splunk-Victor Ops

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator (DBA)

Confidential, Dearborn, MI

Environment: MS SQL Server 2019/2016/2012/2008 R2/2005, MS Access, MySql, Oracle, Mongo DB, GCP-SQL. Windows Server 2019/2014/2012 R2/2008 R2/2003 R2, IIS 8.5/ 8/ 7.5, ESXi 5.5. SCOM, OEM, SCCM, Habitat, Splunk, Dynatrace, Data Tools, Apex, TFS Server, Active Directory, Windows 7/10, ASP.NET, Power BI Tools, Java, UNIX, Linux, Visual Studio, PowerShell,CMD, Flyway, uDeploy, Attunity, Qlicview, Alteryx. AlwaysOn, Mirroring, Replication, Log shipping, SSRS, SSIS, SSAS.

Responsibilities:

• Installing, configuring and managing SQL Server 2019, 2016, 2014, 2012, 2008/R2 in development, testing and production environment.
• Script Deployment, maintaining documentation before script execution. Applying in testing server before implementing in to production server
• Implementing HA/DR techniques to achieve High-Availability in the event of disaster. Implementing Always On in addition to Windows Clustering
• Database Upgradation from SQL Server 2012 to SQL Server 2016
• Database Migration from MS Access to SQL Server
• SSIS/DTS: Creating, deploying and managing SSIS Package (SQL Server Integration Services). Uploading and moving data from flat file, Excel, MS Access, OLEDB Data Sources to SQL Server using export/import and SSIS. For large amount of data implemented BCP/bulk insert. Login and job transfer during upgradation
• Performing monthly system upgrades/maintenance in collaboration wif operation staff and external service providers as needed
• Responds to database-oriented halpdesk requests using ticketing system and escalated to L3 support if needed
• Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools, such as PerfMon, Profiler, DTA, Activity Monitor, DBCC, Execution Plan, DMV, Query Store
• Scheduling jobs to automate different activities such as, back up jobs, monitoring database health, disk/log file space, job alert, index maintenance
• Troubleshooting locking, blocking and dead locking issue. Troubleshooting SQL jobs, databases security, users and roles, permissions and instance level issues
• Supporting 24/7 Production on call based on the rotation

SQL Server DBA

Confidential, Melville, New York

Environment: Windows Server 2012R2/2008R2/2003R2, IIS 8, 7.5, 6.5, SQL Server 2016/2014/2012/2008 R2/2005, ASP, ASP.net, PHP, AD (Active Directory), TFS 2013, IDERA 10, SCOM, SCCM, JIRA, Visual Studio 2013, SAN, RAID, MS Access, MySQL, Oracle, Linux, Java, C#.Net, .Net Framework, ASP.Net, MS TFS, SSRS, SSIS, SSAS. Always ON, Mirroring, Log Shipping, Replication.

Responsibilities:

• Worked as a Production DBA and Responsible for performance of the SQL Server Instance and data integrity
• Configured, and Maintained SQL Server 2008 R2, 2012 in development, test, and production environments
• Installed SQL Server 2014/2016 on a test environment to be the future production environment
• Involved in Migration of Database from SQL Server 2012 to SQL Server 2016.
• Responsible to provide 24x7 DBA and Production support for SQL Server Database in Production Servers
• Involved controlling and co-coordinating the installations (Security Patches, Service Packs) and System Performance before pre-deployment in production.
• Responsible for monitoring and troubleshooting database issues and make tuning adjustments to ensure database integrity, security and system performance.
• Responsible for overall configuration management of the database technologies, including initial database installations, upgrades, and the installation of service packs.
• Managed backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensured dat the backup schedules met recovery requirements.
• Extensive work experience in TempDB configuration, partitioning, shrinking, compression, and database optimization
• Configured Backups, involved in restoring database to point in time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events
• Implemented high availability wif Mirroring, AlwaysOn Availability Groups and Failover Clustering
• Configured, and Administered SQL Server Reporting Services (SSRS), and Developed, Deployed and Managed Reports for associates and upper management using SSRS and Report Builder
• Monitored and Scheduled jobs and created maintenance plans to automate different database administration related tasks including backup and database consistency check.
• Working Knowledge on Azure cloud technologies
• Experience in solving Database issues wif Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling
• Import/Export data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources and used SSIS Packages

Database Admin (DBA)

Confidential, Winona, MN

Environment: Windows Server 2008R2/2003R2/2000, IIS 6.0, SQL Server 2012/2008R2/2005/2000, ASP, PHP, Linux, Java, SQL Sentry, AD (Active Directory), Replication, Mirroring, Log Shipping, Internal (Registration System, Reporting System) and third party applications (Time Sheet, Payroll, HR).

Responsibilities:

• Installed, configured and managed SQL Server 2014, 2012, 2008/R2, 2005 in development, testing and production environment wif latest service packs.
• Backup/Recovery: Creating and implementing backup strategy in the event of disaster. Experience in Point-in-Time recovery. Restoring database from backup and Refreshing database in test and development environment
• High-Availability/Disaster Recovery: Implementing active/passive cluster to achieve HA. Configuring and maintaining database mirroring including automatic fail-over option. Implementing database snapshot to use mirror database for reporting purposes. Configuring Log Shipping as Standby database from Production database for reporting purposes. Configuring and maintaining snapshot and transactional Replications. Implemented Always On in testing environment
• Database Security: Maintaining database security. Troubleshooting security issues. Creating database and application role when necessary. Using Logon triggers for security auditing and creating and managing proxy account
• Database Upgradation/Migration: SQL Server older to updated version. MS Access, Oracle databases into MS SQL Server.
• Patch Management: Applying SP on cluster environment as well as standalone environment. Creating & maintaining documentation on SP & applying hot fixes and CU
• Change Management: Managing changes including all development related works Integrating TFS wif SQL Server and maintaining internal work items
• Data Modeling: Working experience on data modeling projects from end to end including generating scripts for objects, Develop Relationship, and Creates E-R Diagram. Tools used: Toad Data Modeler. Creating and managing Object, Schema, Indexes, Constraints
• Database Monitoring/Performance Tuning: Monitoring database performance using SQL Server native tool such as PerfMon, Profiler, DTA, Activity Monitor, DBCC, Execution Plan, DMV. Scheduling jobs to automate different activities such as, monitoring database health, disk space, job alert, index maintenance, statistics maintenance. Monitoring real-time activities on server using IDERA. Troubleshooting on slow running queries or stored procedure. Using DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance. Using DMV to find current activities on the server
• Report Development: Installing, configuring and administering SQL Server Reporting Services (SSRS). Developing Reports and automate using SSIS. Developing server performance report using IDERA and PerfMon
• Database Programming: T-SQL, Trigger, Functions, Join, Stored-Procedures. Assisting Database Developers to optimize SQL queries and Store Procedures
• SQL Agent: Job creation and troubleshooting job failure. Alerts setup and SSIS package job creation. Implementing maintenance plan and Proxy account

Support Admin

Confidential, New York, NY

Environment: VM Ware, MS SQL, Active Directory & DNS. Windows Server 2003/2005, IIS 6.0, Microsoft Windows 2008/2005/Vista/XP, MS Access, SAN, RAID, Visual Studio, Lite Speed AD (Active Directory), Webex Teams, Cisco Webex

Responsibilities:

• Attended remote sessions, troubleshoot and diagnosed hardware, software issues wif users including logs research, isolation, resolution and follow up steps; provided remote desktop support via webex teams and RDP connection based on SOPs documented
• Responded to on-calls page, emails, instant messages and assigned tickets from client
• Routed work orders, incidents, service requests to appropriate support teams and follow up until closure
• Performed real time Windows server monitoring and troubleshooting steps and escalated to L2 support if required for advanced support
• Performed and managed standard troubleshooting procedure such as Active Directory issues, File server services issues, DNS server services issues, Terminal servers along wif Microsoft application management
• Involved in technical decisions for business requirement, interaction wif client team, development team, capacity planning and upgrading of servers
• Developed reports to provide daily, weekly, monthly quarterly data
• Applied Service Packs and hot fixes on servers