SUMMARY

• Over 7 years of SQL Server DBA experience in MS SQL Server, 2008R2 / 2008.
• Hands on experience in Installing, Configuring, Upgrading, Monitoring and Troubleshooting SQL Server, 2008R2 / 2008.
• Experienced in working with Migrating analysis services databases.
• Experienced in Relational Database Designing based in functional requirements.
• Excellent T - SQL Programming skills. Expert in creating Stored Procedures, User-defined Functions, Views, Triggers.
• Experienced in database Back Up and Restore.
• Experienced in configuring Security and Permissions in both Server level and Database level.
• Hands on implementing SQL Server High Availability options for Disaster Recovery, including configuring Replication, Log Shipping, Database Mirroring, Always On and Failover Clustering.
• Worked on SQL Server Profiler, Database Engine Tuning Advisor, viewed Execution plan, Improved Performance Tuning, Maintained Indexes and Statistics, Monitored and Optimized Databases.
• Experienced in Extracting, Transforming and Loading (ETL) data from data source to data destination and Configuring ETL Packages in SSIS.
• Worked on SSRS.
• Worked on SQL Server Agent, Configuring Jobs, Operators, Alerts and scheduling Packages.
• Data Modeling Experience including Physical and Logical data modeling.
• Experienced with Administering Large Databases, which is of size above 3 terabytes.
• Worked on space issues.
• Configured Domain Control, installed and configured Active Directory Service.
• Experienced working in Windows Server R R2.
• Good team player, self-motivated person with excellent analytical, problem solving and communication skills.
• 24 / 7 on call support.

TECHNICAL SKILLS

• SQL Server / 2008 R2 / 2008
• Windows Server 2012R2 / 2012
• 2008R2 / 2008
• Windows 10, 8 / 8.1, 7
• XP
• 98
• SQL
• T-SQL
• HTML
• CSS
• Matlab
• Basics in JavaScript
• PHP
• Python
• SQL Server Management Studio (SSMS)
• MS Visual Studio
• SQL Server Integration Services (SSIS) for ETL
• SQL Server Profiler
• Database Engine Tuning Advisor
• MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server Database instance in a Clustered environment.
• Worked with database Migration, migrated data from SQL Server 2012 to SQL Server 2014.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production / development servers as per business / IT needs.
• Daily routine DBA tasks like handling user’s Permissions and database Security.
• Implemented Transactional Replication as Disaster Recovery Solutions.
• Working with SQL Server 2012 and SQL Server 2014 Always On High Availability.
• Involved in Performance Tuning including Monitoring, Troubleshooting and Optimizing performance of the databases.
• Extensively used SSIS to perform the ETL operations.
• Loaded data from multiple sources through SSIS.
• Involved in implementing active-passive clustering on Windows Server 2012R2 Operating system with consolidated environment of multiple SQL server instances in SQL .
• Developed stored procedures, views, triggers and user-defined functions.
• Designed Data Integrator jobs with Error Handling and email notification.
• Handled up to 3TB size databases with clustered environment.
• Configured space issues on Production and Test Servers.
• Assisted other associates at Online technology in the technical understanding and abilities of data architecture.

Environment: SQL Server, Windows Server 2012 R2, SQL Server Management Studio, SQL Profiler, Database Engine Tuning Advisor, Excel, SSIS.

Confidential - San Diego, CA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2014, 2012, 2008R2.
• Developed database designs based on the functional requirements.
• Worked on project teams to develop target logical and physical data models.
• Used T-SQL to create triggers, views, user-defined functions and stored procedures.
• Performed daily tasks including backup and restore by using SQL Server 2008R tools.
• Participated in developing Security and and user’s Permissions.
• Implemented Always On HA groups and trouble shooting.
• Worked with optimizing and tuning the queries.
• Exported and imported data from other data sources like flat files using Import / Export through SSIS.
• Worked with space issues on Production Servers and handling maintenance Jobs.
• Ensured the systems are functioning optimally and that users are able to upload.
• Analyzed content and quality of databases, recommended data management procedures.
• Worked on Entity Relationship Diagrams.
• Assisted in client support and setup configurations.
• Technical Analysis, Code Review, Implementation, 24 / 7 production support.

Environment: SQL Server / 2008 R2, Windows Server R2, SQL Server Management Studio, SQL Profiler, SSIS, ERWIN, MS Office 2012.

Confidential, Seattle, CA

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2008R2 / 2008 to SQL Server 2012 on various production servers.
• Migrated Databases from SQL Server 2008R2 / 2008 legacy application to SQL Server 2012.
• Worked with table compression, database compression and merge statements using SQL Server 2012.
• Worked with ‘insert’ commands to INSERT data if it does exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2012).
• Created complex stored Procedures, Triggers, Tables and Other SQL Joins and Statements for Applications by using T-SQL.
• Worked with database Security and backup.
• Worked in Active-Active Cluster environment as a High Availability solution.
• Used Log Shipping for synchronization of databases.
• Database Mirroring as a Disaster Recovery Solution.
• Worked on new HV features Always On in SQL Server 2012, to replace Database Mirroring.
• Tuning queries which are running slow using Profiler and Statistics by using different methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Performed daily, weekly and monthly data maintenance tasks.
• Configured ETL packages through SSIS.
• Worked on SSRS, generated drill down report, parameterized report, subreport, chart report.
• Provided 24 / 7 production support.

Environment: SQL Server / 2008 R2, Windows Server R2, SQL Server Management Studio, SQL Profiler, SSIS.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server R2.
• Worked in Active-Passive cluster environment.
• Wrote and debugged Stored Procedures and (DDL / DML) Triggers, Functions, Views as per client requirements.
• Wrote T-SQL scripts for database back up jobs and daily / weekly jobs.
• Implemented Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Implemented Transactional Replication.
• Implemented and maintained Log Shipping, and Mirroring as a Disaster Recovery solution.
• Did performance Tuning of the Stored Procedures.
• Monitored scheduled jobs.
• Worked on Very Large Databases (VLDB) over 100GB for OLTP and 2TB for OLAP databases.
• Monitored Disk Spaces on all the servers.

Environment: SQL Server R2, Windows Server 2008 R2, SQL Server Management Studio, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server R2.
• Involved in Relational Database Design based on the functional requirements.
• Developed queries and various database objects like Stored Procedures, Views, Triggers and User-Defined Functions.
• Implemented Replication and Database Mirroring as a part of Disaster Recovery Plan.
• Did Performance Tuning of the Stored Procedures.
• Configured ETL Packages in SSIS.
• Managed and scheduled daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Involved in trouble shooting database issues.
• Loaded data to Data Warehouse through SSIS.
• Managed the use of Disk space, memory and connections.

Environment: SQL Server R2, Windows Server R2, SQL Server Management Studio, SQL Profiler, SSIS.