SUMMARY

• Have strong 6+ years working experience on Database Design, Development and Administration on Microsoft SQL Server (2017/2016/2014/2012/ 2008 R2/ 2008/ 2005) in Prod, Development and Test Environments.
• Expert in RDBMS concepts and constructs to design relational databases model and implementation as per business needs.
• Have solid professional knowledge and experience on Advanced Installation and Configuration of SQL Server, Monitoring and Health Check, Reporting, and Maintenance with troubleshooting capabilities.
• Extensive work experience in applying latest Service Packs, Patches, and Hotfixes.
• Good experience in automation of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent.
• Experience in managing database security, Logins, Users, Roles, and Object permissions and implementing Contained Databases.
• Experience using features like Policy Based Management, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Hands on experience in configuring, monitoring, and administering AlwaysOn, SQL Server Cluster, Log Shipping, and Replication.
• Installed, Configured and Maintained Database Mirroring using automatic Fail - Over in SQL Server
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Strong knowledge and experience in implementing disaster recovery solutions, database Backup, Restore, and Point-in-Time Recovery in accordance with RTO and RPO guidelines.
• Proven experience in the areas of Troubleshooting, Performance Tuning, Monitoring Server & database health, disk space utilization, query optimization.
• Experience in analyzing Locks, Dead Locks using Extended Events Session and Handling the Isolation Level and Concurrency Effects.
• Experienced in upgrading SQL Server (2005/2008/2008 R2) instances to SQL Server 2012/2014/2016/2017
• Expert in using Bulk Copy Program (BCP), Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Skilled in ETL Operations, Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using SSDT
• Developed, deployed and implemented security for SSIS Packages
• Configured and automated SQL Server Agent jobs using SSIS packages
• Establishes and builds strong working relations and partnerships with Business Units and Senior Management
• Having excellent verbal, written and presentation skills, Independent problem solving, team player, proactive, multi-tasking and prioritizing skills, detail oriented and excellent interpersonal skills

TECHNICAL SKILLS

RDBMS & Tools: SQL Server 2016/2014/2012/2008 R2/2008, MS Access, PowerShell

Operating Systems: Windows Server 2012R2/2012/2008R2/2008, VMware

Database Tools: SSMS, SSIS, DTS, DTA, BCP, ODBC, BI Studio, Enterprise Manager, Upgrade Advisor

ETL Tools: SSIS/DTS, BCP

Reporting & Audit: SSRS, SSDT, Report Builder, Idera SQL Compliance Manager

Data Modeler: SSAS, TOAD Data Modeler

Languages: T-SQL, PL/SQL, .NET, JavaScript, HTML, ASP, XML

Third Party Tools: RedGate, Spotlight, Idera

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential - Dallas, TX

Responsibilities:

• Install, configure, and maintain SQL Server Enterprise in production, test, and development environments.
• Automate day-to-day operations, critical SQL server alerts and repetitive tasks.
• Monitors performance of SQL Server instances using native and third-party tools.
• Maintained server level, database level and object level security best practices by creating Logins and Users (Contained Databases), configuring permissions and assigning different roles to users.
• Develop maintenance plans, backups, index management, fragmentation management, cleaning history, deleting old files.
• Performs performance tuning for Server, Database, and Query; uses Profiler, Execution Plans, Perfmon, Counters, Database Tuning Advisor, and third-party tools Idera and Spotlight.
• Successfully performed in-place, side-by-side migration and handled post migration issues.
• Configured, maintained, and troubleshoot AlwaysOn Availability Groups, Log shipping, Failover cluster and Replication.
• Perform Database Refresh.
• Initiates backup and recovery; designed backup strategies for development, test, production and mission-critical systems including Point-in-Time Recovery, automation, and test procedures.
• Created operators, Jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Created SSIS Packages to Extract, Transform and Load data into database.
• Address security and upgrade issues by applying Service Pack / Hot Fixes on SQL Server.
• Provide 24/7 on-call support on rotation basis for production databases

SQL Server DBA

Confidential - Cincinnati, OH

Responsibilities:

• Performed installation, configuration, and maintenance of SQL Server 2012 and 2014.
• Designed the database backup and recovery strategy; monitored to ensure backups were completed, was able to recover database to a specific point-in-time, per requests or during outages.
• Conducted troubleshooting of database issues; resolved performance problems; ensured data optimization.
• Collaborated with infrastructure and development teams to ensure database availability.
• Created server logins, database users, custom database roles, assigned users to specific roles and ensured only the required privileges are granted to the users
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Proactive in reviewing security logs, user logins within SQL server and third-party solution to prevent breach or violation.
• Apply various replication and HADR models including log shipping, Configured SQL Server Replication between Publisher and Subscriber server, database mirroring, AlwaysOn and Clustering.
• Database migration between various database servers.
• Configured & Managed Database and Data Security Solutions applying TDE (Transparent Data Encryption), Row Level Security, Column level encryption, Dynamic Data Encryption, Role based Security Policy, Security Auditing.
• Setup new backup procedures and jobs to automate the backup process.
• Check for the failed jobs and investigate the root-cause analysis for maintenance jobs that runs against temp tables, logs, history, backup files etc.
• Developed & implemented database maintenance plans like, Index rebuild or re-organize, update statistics.
• Performed Database Refresh.
• Troubleshoot performance issues related to query optimization, tempdb, log file growing fast, identify and release Lock, block and deadlock.
• Used SQL Server Profiler, Extended Event, Query store, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.
• Installed, Configured and administered SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
• Exported, imported data from SQL Server to Text file, Excel file and CSV format using SSIS packages and also BCP/SSDT
• Commitment to excellent customer service with 24x7 on-call support.

Jr SQL Server DBA

Confidential

Responsibilities:

• Upgraded and migrated SQL Servers.
• Utilized DBCC and DMV for a variety of purposes.
• Managed indexes; created the backup/restore strategy for both production and development.
• Performance tuned for improvement; included SQL/TSQL code using Query Execution Plan, Database Tuning Advisor, Profiler, Monitoring Lock/Block, and Sessions.
• Instrumental in database mirroring, log shipping, replications, and clustering.
• Wrote T-SQL, and stored-procedures for reports and applications.
• Loaded data; performed conversion from flat file, CSV file and Excel.