SUMMARY

• Over 8+ years of IT Experience in SQL Server database developer, database admin, System Analysis, Design and Support of Microsoft SQL Server / R / 2000 in Development, Test and Production Environments on various business domains.
• Extensive work experience in Installation, Configuration & Maintenance of MS SQL Server - Standalone/ Networked/ Clustered/ Virtual Environment.
• Creating Databases, Transactions, Tables, Indexes, Constraints, Writing and Debugging Stored Procedures, Triggers, Views, Functions and Cursors using SSMS.
• Installation and configuration of Microsoft reporting, analysis, and integration services (SSRS,SSAS,SSIS), ETL experience.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs.
• Experience in Performance Tuning and Query Optimization.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability.
• Extensive experience in implementing High availability and Disaster Recovery solutions like Always On Availability groups, Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines.
• Implemented new features in MS SQL Server 2012 like Always On HADR in production and non-production environments.
• Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in Replication, Clustering, Mirroring and other distributed data issues.
• Experience with SQL Server Security and SQL Server Auditing.
• Created different types of encryptions and decryptions in SQL Server as per the client requirement to secure the data and also use it in flexible ways by a group of users.
• Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SQL Server Integration Services (SSIS), BCP and DTS utility.
• Worked with tools like SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance.
• Sound understanding of change control and helpdesk ticketing processes.
• Applied Service packs and hot fixes during off hours.
• Expert in developing PL/SQL Packages, implementing business logic in backend using Stored Procedures, Triggers, Views, Scripts, Functions and Cursors.
• Also developed various applications using Oracle in-built packages.
• Experience in Migrating SQL servers from R2 and 2008R2 to 2012.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Set up database Backup jobs for more efficient recovery by setting up Full/Differential Backup and more frequent Transaction Log Backup for more dynamic databases.
• Actively involved in Data Center Consolidation and planning.
• Expert in logical and physical modeling for OLTP and OLAP applications Knowledge in developing T-SQL queries (DDL and DML).
• Experienced in creating Tables, Views and other SQL joins and query writing.
• Expert in creating Clustered and Non-Clustered Indexes to improve the performance of the SQL queries.
• Handful experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR) - Log Shipping, Mirroring (High safety, High performance & High availability), Replication (Snapshot, Merge, Transactional & Peer -to- Peer) and Clustering (Active-Passive & Active - Active).
• Extensively worked on Active-Active and Active-Passive Clustering.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in using third party tools, for Data modeling SQL Diagrams Erwin, for Backup Solutions SQL LiteSpeed, for performance Foglight, and for alerting Idera.

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential, Minneapolis, MN

Environment: SQL server 2008 R2 and SQL Server 2014, T-SQL, SSIS (ETL), SSRS, Windows 2008 and 2012,2014 Servers.

Responsibilities:

• Experience in Installing and configuration of SQL Server 2014.
• Migrated from SQL server 2008 R2 to SQL server 2014.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Configured ALWAYS ON setup between different DATA Centers and on Multi Subnet Cluster.
• Performing Backup/Restore to/from Disk.
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Expert in configuring Temp DB.
• Configured Transactional Replication and Log Shipping with SQL Server Management
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning.
• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications. Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

SQL Server DBA

Confidential, Los Angeles, CA

Environment: SQL Server 2005, 2008, 2008R2, T-SQL, Excel, Advanced Windows 2000 Server, Visual Source Safe 6.0 Version Control Management), 2003/2005.

Responsibilities:

• Managed and Administrated theSQLServer 2008/2005/2000 production and Non Production servers.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Designed a report on the monitoring ofSQLServer Performance.
• Worked withSQLServer 2005 side by side upgrade fromSQLserver 2000.
• Performed daily tasks including backup and restore by usingSQLServer 2005 tools likeSQL Server Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.
• Implementation ofSQLLogins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Developed SSIS Packages, stored procedures, functions, triggers.
• Involved in all tasks associated with daily operations such as database availability, monitoring activity, installations and back-up strategy.
• Performance tuned the Databases by consistently monitoring the job durations and also the type of execution plans used by the processes, Indexes used in order to maintain the data integrity.
• Worked in documenting the entire process of recovering the Databases using Disaster Recovery Planning.
• Worked in taking the backups in regular intervals.Worked closely with the end users and the reporting team to meet there goals.

SQL server developer/DBA

Confidential

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Business Objects, T -SQL, ERWIN Data Modeler, SAN, DTS, SSAS, SSRS, SSIS, Crystal Reports.

Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements. Implementing Backups and restoring when necessary.
• Creation and management of Database maintenance plan for various database Consistency checks.
• Extensively working on performance issues like update statistics, Auto Stats.
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Creating monthly transaction report for all sections. Developing of Multi-Lingual Reports Using Crystal Reports.
• Designed and Implemented Reports using Business Objects Full Client.
• Reports were developed using Crystal Reports utility.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries. Involved in planning, designing, configuring and implementing SAN fabric.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Converted and redesigned existing DTS packages to SSIS packages.
• Created SQL Server Agent Jobs to automate tasks such as to run Index Maintenance, Index defrag, Rebuild, Update.

SQL Server DBA

Confidential

Environment: MSSQLServer 2008 and 2005, T-SQL, Erwin, SSAS, SSIS (ETL), SSRS,, Excel, Windows 2003/2008 Server.

Responsibilities:

• SQL Server 2005 Database Administration.
• Installed and configured more than 2GB RAM in SQL Server 2005.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise in SQL Server Analysis Services.
• Expertise in creating and supporting in OLAP Cubes.
• Provide On-Call support 24*7.

SQL Server DBA

Confidential

Environment: MS SQL Server 2000/2005, Windows Server 2000/2003, Enterprise Manager, Query Analyzer, Java, and Windows 98/Vista.

Responsibilities:

• Managed database and SQL Server security by granting appropriate role to user and logins.
• Install and configure SQL Server 2005 and applied Microsoft Security Patches.
• Troubleshooting database and server performance issue.
• Scheduled backup and weekly maintenance plan.
• Actively involved in daily health check monitoring.
• Monitor DR site and its synchronization status.
• Perform database refresh from Production to Development server to support ongoing development activity.
• Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL.
• Maintaining scheduled process and batch jobs.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Data conversions and data loads from various databases and file structures.
• Generated reports using Crystal reports.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.