SUMMARY:

• Around 5 years of experience in Database Administration and Development for very large and complex databases in SQL Server 2016/2014/2012 /2008 R2/2008 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.
• Hands on using Oracle Database Administrator of 11g in development and production environments.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2016/2014/2012 /2008 R2/2008.
• Experience in maintenance, monitoring, Backup/Recovery for the various Environments.
• Experience in Disaster Recovery planning by configuring Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Experience in RDBMS installation, database server builds, applying patches, Applying patches in VM environments, upgrading, configuring, and trouble shooting of SQL SERVER on Windows 2008/2012/2014 servers.
• Experience with new features: Data Compression, Transparent Data Encryption (TDE).
• Experience in configuring Replication and troubleshooting the issues with transactional replication and Merge Replication.
• Experience in Configuring High availability groups and troubleshooting.
• Experience in 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, Replication, Linked Servers and Database Maintenance Plan.
• Maintained User Permissions, Logins and Security Issues. Monitored Event Viewer’s, SQL Error logs and Log Files Viewer for Software and Hardware errors.
• Experience on 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.
• Involved in Change Control Management Process for maintaining the consistency of databases.
• Experience in raising the Service Requests and keep tracking of requests.

TECHNICAL SKILLS:

Databases: SQL Server 2008 R2, 2012, 2014, 2016, Oracle 10g/11g

Operating Systems: Windows, Linux, Solaris and HP-Unix

Tools: SQL plus, SQL Developer, PL/SQL Developer, ETL, MSBI, SSIS, SSRS, SSAS, SQL Server management, Microsoft Visual Studio, Always-On, Toad.

Programming Languages: PL/SQL, T-SQL, shell Scripting, MS-Access, HTML, CSS.

PROFESSIONAL EXPERIANCE:

Confidential, Louisville, CO

DBA/ Developer

Responsibilities:

• Installation, Configuration and Upgrade of MS SQL Server 2008/2012/2014 and 2016.
• Involved in SQL Server capacity planning.
• Installation of SQL Server Instances on VM ware standalone machines & Clustered nodes.
• Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Maintained Security, Roles and Privileges to users.
• Configured and supported transactional replication.
• Configured Database mirroring & Transactional replication as per the project requirements for critical applications.
• Worked with importing data from legacy databases like DB2, Access & Flat files using BI tool SSIS.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• Designed and Created tables, views, stored procedures and triggers.
• Created DTS/SSIS Packages to pull data from Oracle, Sybase, MS Access and Flat files for a Data warehouse project called ‘Legacy Archive Decommissioning’
• Involved in restore operations to refresh the data from production to test servers.
• Worked Database Migration from SQL Server 2008 R2 to SQL Server 2016.
• Implemented Backup, Restore and Disaster Recovery procedures.
• Used performance-monitoring tools like SQL Profiler, SQLDiag, Blocker Script and System Monitor.

Environment: Windows 2014/2012, MS SQL Server 2016/2014/2012, PowerShell, AZURE, MDS, SQL Server Data tools BI, Oracle 10g/11g, Toad.

Confidential, Boston, MA

Junior SQL Server DBA (Intern)

Responsibilities:

• Created Database Maintenance Planner for the Performance of SQL Server.
• Installed SQL Server 2012 and SQL Server 2008 R2 on windows 2008 R2, applied service packs and security fix for all servers.
• Scheduled Database Backup and maintained.
• Implemented Database Mirroring on SQL Server 2008 environments.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh.
• Managed Publisher, Distributor and Subscriber database environments for the replication.
• Used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle Server and SQL Server.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control in SSIS.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Worked with Senior DBA's and developers to do the database schema changes and database restore request.

Environment: Windows 2012/2008, MS SQL Server 2016/2014, PowerShell, SQL Server Data tools BI, Oracle 10g/11g,Toad.

Confidential, Omaha, NE

MS SQL Server DBA/ Developer

Responsibilities:

• Working on the SQL Server 2012/2008/2005 instances in production and pre-production servers.
• Working on day-to-day tactical break/fix and troubleshooting issues related to SQL Server pre-production, Production systems.
• Maintaining backups (including tape library) and backup strategy.
• Performance troubleshooting and tuning (SQL Server, web services, etc.) stored procedures and SQL queries.
• Working with DBA team and Development teams on database health (performance counters, blocking, deadlocking, fragmentation levels, database growth trends, TOP queries.
• Respond to service requests for Database queries, data configuration changes, data analysis, and server and database permissions requests.
• Determining root cause of incidents and escalating bugs to dev teams and supporting the environment through incidents, Service Request and preparing RFC's and PIR (post incident Reviews)
• Involved in setting up of disaster Recovery Site in a datacenter and migration of databases from one datacenter to another.
• Granting access to internal tools and databases and managing the Security by creating Security groups adding users to them appropriately.
• Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments)
• Analysis and implementation of OS Patch upgrades, Service packs upgrades, etc. every month to keep the servers up-to-date on the patch level for better performance.
• Extensively worked on setting up Mirroring, Log shipping and Replication and Always on in Prod and Non-prod Servers.
• Involved in Data center migration.
• Involved in database design, database standards, T-SQL code reviews.
• Created, scheduled database maintenance plan using SSIS Maintenance plan task.
• Configured and deployed and supported SSIS Packages and migrating from preproduction to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services (SSRS).
• Migrating database objects from preproduction to production environment.
• Experience in planning and implementing Disaster Recovery solutions, Backup/Recovery strategies, Performance Analysis etc.
• Used DMVs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes etc. for query/stored proc tuning. Extensively involved in Index tuning.

Environment: TSQL, MSSQL SERVER 2005/2008R2/2012/2014, SSRS, SSMS, VISUAL STUDIO 2010/2012, WINDOWS Enterprise Server 2003/2008/201, Linux, Virtual box.

Confidential, Detroit, MI

SQL DBA/ Developer

Responsibilities:

• Installation, Configuration and Upgrade of MS SQL Server 2000/2005/2008/2012.
• Installation of SQL server Instances on VMware standalone machines, Clustered nodes.
• Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Maintained Security, Roles and Privileges to users.
• Maintain larger database environment of over 6 TB.
• Configured Database mirroring & Transactional replication as per the project requirements for critical applications.
• Worked with importing data from legacy databases like DB2, Access & Flat files using BI tool SSIS.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• Designed and Created tables, views, stored procedures and triggers.
• Implemented Backup, Restore and Disaster Recovery procedures.
• Coordinating with the development team regarding tuning the SQL queries and stored procedures.
• Created stored procedures as a part of Query Optimization.
• Created different database maintenance plans for database optimization, integrity checks and database backups.
• Migrating databases from one server to another.
• Involved in Security Administration- creating users and assigning them roles and privileges.
• Monitored and scheduled existing/new jobs on production environment.
• Worked with SQL Performance Tuning and Query Optimization.
• Maintained multiple instances SQL Servers with maximum availability.
• Upgraded with latest hotfixes for all Development/Test/Production Servers.
• Worked for Database migration from Oracle 11g to MS SQL Server.
• Extracting and transforming data from an external data source i.e. Oracle 11g, Access, DB2, Flat files to a SQL Server database by using ETL tool, SSIS.
• Maintained good communication along the team members.
• Maintained documentation of daily Passdown tasks.
• Supported 24 X 7 production environment.

Environment: MS-SQL Server 2008R2/2012, Windows 10/8/7, Linux, Visual Studio, SSIS and SSRS, VMware machines, Visual Studio, HTML, XML.