SUMMARY:

• 6 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 in a variety of environments and sectors.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server, internet environments.
• Installing, Upgrading, migrating maintaining, monitoring, Backup/Recovery databases in and from SQL Server 2016, 2014/2012, 2008R2, 2008, 2005.2000.
• Expert in Disaster Recovery planning by configuring Clustering, Log-shipping, Mirroring and Replication. Handled up to 2 TB databases in Clustered environment with good Physical storage configuration.
• Expert in patches in VM environments, upgrading, configuring, trouble shooting of Windows Servers 2008/2012 and Clustered VMware Environments.
• Experience with command line utilities, including Power Shell.
• Experience in configuring Clustering in Active-Active and Active-Passive nodes, Replication and troubleshooting the issues with transactional replication and Merge Replication, Configuring Log shipping, Mirroring, High availability groups and troubleshooting.
• Experience in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries and query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in tuning the long running Queries and Store Procedures by examining the execution plans. Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defragging Tables, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and other RDBMS like Oracle Databases.
• Experience in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Experience in Planning and Scheduling Maintenance Tasks and Scheduling Jobs and Alerts using SQL Mail. Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Experience in Team Foundation Version Control for TPC. Maintaining the Service Level Agreements (SLA’s) according to the client’s requirement. Experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Migrating the DTS Packages to SSIS Packages by using Package migration Wizard. Ability to quickly adapt to new environments and to continuously learn and apply new technologies and excellent written and verbal communication skills, customer relation and service ability .

TECHNICAL SKILLS:

Databases: MS-SQL Server 2012/2014/2016, Oracle 12c, 11g.

Oracle Tools & Utilities.: Import, Export, Data Pump, SQL*Loader, SQL Trace, RMAN, VI Editor.

SQL Server Tools.: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import

Operating Systems: Windows 10/8/7, Windows Server 2012/2008, Linux Red hat Version 6.0

Software Packages: Visual Studio 2015, MS Office 2003/2007/2013, Macromedia Flash, Adobe Photoshop

ETL Tools: MS-SQL Server (SSIS), Oracle Data Integrator.

Languages: PL/SQL, Transact-SQL, HTML, Visual Basic, Unix Shell Scripts, Power Shell.

PROFESSIONAL EXPERIENCE:

Confidential, Utah

SQL Database Administrator

Responsibilities:

• Performed SQL Server 2016/2014/2012/2008 R2 database administration.
• Installed, managed, and administrated MS SQL Server 2012/2008R2 production and non-production servers.
• Migrated SQL Server 2008R2 to SQL Server 2012.
• Implemented SQL Server 2012 new features such as always on availability groups for high availability of multiple databases in place of database mirroring.
• Provided data refreshes from production to test environments, automated whole data refresh process at database level utilizing Power Shell scripts, stored procedures, backups and SQL Agent jobs without having any performance impact on the production server.
• Monitored log shipping/transactional replication and troubleshot errors.
• Utilized Profiler, Perform Counters, DMVs, DMFs and DTA to tune databases, servers and query tuning.
• Developed Power Shell scripts in place of T-SQL batch script for daily maintenance activities to improve performance and scheduled scripts in central management server.
• Implemented database mirroring and transactional replication as a part of DR plan.
• Rebuilt indexes with different fill factors and updated statistics manually.
• Maintained SQL Server security including creation of logins and users, configuring permissions, and assigning roles to users as required.
• Configured database alert scripts such as database size increase, log size full, maintenance script for all SQL Server versions.
• Utilized Database Consistency Checks (DBCC) commands for database maintenance.
• Detected and resolved locks and deadlocks utilizing trace flags and native tools such as profiler and activity monitor.
• Index tuning wizard for optimal query performance.
• Setup and configured Always on Availability Groups for DR and reporting.
• Performed all aspects of database administration, including backups and recovery.
• Managed orphan users while moving databases.
• Utilized SSIS to populate data from various data sources and also in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases.
• Scheduled weekly jobs and maintenance tasks for better performance. Created alerts with Database Mail SMTP.
• Provided on-call 24/7 support to databases on weekly rotation.
• Created and modified tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Created DB objects such as tables, stored procedures, views, and triggers as required.
• Utilized SSRS to create reports that draw content from a variety of data sources.
• Defined DB scripts versioning system to keep track of database versions for all environments.
• Experience in using Power Shell Scripting language.
• Prepared reports for day-to-day as well as weekly/monthly purposes.
• Determined database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with organization policies.
• Monitored, determined, and solved issues at SQL/database/server levels.
• Performed all aspects of database administration, including data modeling, backups and recovery.

Environment: T-SQL, MSSQL Server 2005/2008R2/2012/2014, SSRS, SSMS, Visual Studio 2010/2012, Windows Enterprise Server 2003/2008/2012, IIS, RMAN, Linux 6.0 RHEL, Virtual Box.

Confidential, Chicago, IL

SQL Server Database Admin

Responsibilities:

• Created and maintained various databases for production, development and testing environments using SQL Server 2008R2, 2005.Migrated SQL 2005 to SQL 2008R2.
• Performed daily backups and developed recovery procedures.
• Setup Active-Active/Active-Passive clustering in production and testing environments and also troubleshot issues. Applied hot fixes and service packs in clustering environments.
• Conducted database mirroring in high performance and high availability mode and troubleshot issues with witness servers.
• Performed administration, database design, performance analysis, and production support for large (VLDB) and complex databases, up to 2 Terabytes.
• Migrated data across different databases and different servers utilizing SSIS, BCP and import/export tools.
• Executed performance tuning utilizing windows performance monitor and SQL profiler of SQL Server. Utilized SQL Server error logs and event viewer to troubleshoot issues.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Troubleshot issues with log file full and database size increasing Confidential threshold.
• Provided Change Control Management by identifying and controlling change requests to a project from both internal and external sources. Provided support to application developers on application databases.
• Managed database components of application releases and 24/7 production issues.
• Managed SSIS packages, stored procedures, jobs, and utilized Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Developed few reports utilizing MS SQL Reporting Services.
• Created database and database objects such as tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions.
• Performs refreshes from production backup to stage and development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting/Ad Hoc reporting.
• Collaborated with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts, etc.
• Extracted data from various sources such as SQL Server 2005/2008, Oracle, Teradata, CSV, Excel and Text file from client servers and through FTP.
• Developed and deployed stored procedures, created triggers, and audits.
• Developed jobs for maintenance by updating statistics, rebuilding indexes, scheduling full/diff/log backups, and refreshing database environments. Set up notifications for failure of jobs, etc.
• Determined database schema, database schema changes, and implementation plan for database schema releases in coordination with developers and data modelers in adherence with organization policies.
• Monitored, determined, and solved issues at SQL/database/server levels.

Environment: Windows 10/8/7, MS-SQL Server 2008R2/2012, Visual Studio, i3 Performance Tool, SSIS, SSRS, Sites Scope Monitoring Tool, IDERA Tool, VMware Machines, Visual Studio, HTML, XML.

Confidential

SQL Server Database Admin

Responsibilities:

• Planned and installed SQL Server 2005, 2008 on production and development servers.
• Installed service packs and hot-fix for SQL Server 2005 in all development and production environments.
• Migrated existing 2000 databases to SQL Server 2005 (side by side).
• Developed backup strategies based on recovery models.
• Scheduled daily backups for database and transaction log and restored databases and transaction log on production/development servers as per requirement.
• Created logins, tables, clustered and non-clustered indexes, views, functions and stored procedures.
• Raised change management request and followed up with customer for approval to make changes in production server.
• Utilized DTS/SSIS Package and DTS Import/Export for transferring data.
• Implemented database maintenance plan for database consistence & integrity.
• Provided on-call 24/7 support to databases on weekly rotation.
• Exported or imported data from other data sources such as flat files utilizing import/export through DTS, SSIS.
• Utilized SSRS to build health check reports & deploying the SSRS.
• Utilized data driven subscription to prevent unforeseen circumstances.
• Monitored SQL Server performance utilizing profiler to find performance and deadlocks.
• Monitored and troubleshot SQL cluster, mirroring, and log shipping.
• Created jobs using maintenance plans for full, differential and transactional log backups.
• Recovered many databases at the time of database crashes or data loss.
• Performed SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Maintained and monitored production, pre-production and development database server environment.

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Composite Software 5.0.0, Report Builder, Lite Speed, BCP, SSAS, ETL, Windows 2003/ 2008R2 Server, SSIS, SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T - SQL codes maintaining query standards for the project.
• Created ER diagrams
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added
• Columns, triggers and configured IIS and Worked on Index tuning, stored Procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using ERWin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in
• Development and Production environment for SQL Server 2000\2005.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.

Environment: MS SQL Server 2000/2003, Excel, Query Analyzer windows NT/2000 server & Professional