SUMMARY

• 8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R 2/ 2008/2005/2000 in OLTP and OLAP environments.
• Very good Knowledge of Relational Database Management System (RDBMS).
• Experience with Building SQL Server Windows Clustering, VM and Standalone servers with all versions of SQL Server and their Installation, Configuration and Maintenance.
• Hands on SQL Server Always ON availability groups, column store Indexes and In - Memory Tables.
• Experience in Migrating SQL servers from R2 and 2008R2 to 2012.
• Migrated from a SQL2008 virtualized Platform to a highly automated, virtualized SQL Hybrid Cloud Platform utilizing the latest compute and storage technology to offer maximum performance, availability and security.
• Documented Disaster Recovery plans and participated in DR drills.
• Troubleshooting production issues and raising high availability.
• Data Migration from SQL Server and Non-SQL Server Systems like Oracle and Sybase.
• Restoring Databases and Designing Backup Strategies for higher retention time.
• Experience in implementing features of SQL Server 2008 like Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.
• Expertise in Performance Tuning, Indexing, monitoring SQL Server, using Database Tuning Advisor, SQL Profile (dead locks/ long running queries), Windows Performance Monitor and Database Consistency Check using DBCC Utilities.
• Experience in transforming data from different sources like Oracle, Excel, Flat file, Sybase to MSSQL Server by using BCP, DTS, Bulk Insert and SSIS.
• Extensive experience with data modeling, dimensional modeling, logical and physical database design.
• Automated process by creating jobs, maintenance plans and error reporting using Alerts, SQL Mail Agent.
• Experience in Disaster Recovery & Capacity Planning models for corporate databases.
• Implemented different types of Replication Models, Database Mirroring modes and Clustering environments (active/passive and active/active) to further increase scalability and stability of business critical systems.
• Implemented backup policy using Full, Differential, Transactional and Disaster Recovery Procedures.
• Knowledge of T-SQL and PL/SQL Database programming development of complex Stored Procedures, required Functions, Cursors, Triggers and Views.
• Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS).
• Experience in administration of SQL Server Reporting Services (SSRS) and Analysis Services (SSAS).
• Worked in financial, IT Management various other field.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes and Unattended Installations.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Good communication and written skills and can handle multiple projects simultaneously.
• Worked 24 x 7 for production support with multiple SQL Instances.
• Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.

TECHNICAL SKILLS

RDBMS: SQL Server …

Database Tools: Management Studio, BI Development Studio, SQL Profiler, Data Transformation Services (DTS), SQL Server Integration Service (SSIS), Share point, SQL Server  Analysis services (SSAS), SQL Server Reporting services (SSRS), Erwin, Microsoft Visio.

Languages: SQL, TSQL, Visual Basic 6.0, HTML

Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook Express.

Applications: Microsoft Office, Erwin, MS VISIO …

Operating Systems: Windows … R2 and win 7, XP, Linux, MS-DOS.

PROFESSIONAL EXPERIENCE

SQL Server DBA / Developer

Confidential, Irving, TX

Environment: MS SQL Server 2000/20 \2014, Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, Perl, power shell script, Erwin, companion, Idera, Sybase TSM/TDP.

Responsibilities:

• Manage and administer SQL server 2000\2005\2008\R2\2012\2014 servers.
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012/2014.
• Configured ALWAYS ON setup between different DATA Centers and on Multi Subnet Cluster.
• Configured Windows Fail Over Clustering and SQL Clustering on Multi Subnet Cluster.
• Deployment of databases, jobs, cubes from pre - production to production.
• Building SQL 2005\2008\2012\2014 cluster environments on VMware or Physical windows.
• Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers Upgradtions of SQL server versions and applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability Configured Transactional Replication and Log Shipping with SQL Server Management Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Continuous monitoring server health with Idera monitoring tool.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Configured Database mail, linked servers, Extensively worked on Transparent Data Encryption (TDE) and Auditing.
• Performance tuning of databases by windows performance monitor and SQL Profiler.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Used the Power shell scripting to get the most consistent production environment.
• Experience on working with File Maker Pro.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents within the SLA s, as a part of operations support DBA.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams
• Involved in capacity planning, sizing and database growth.
• 24*7 on call production support.

SQLServer DBA/Developer.

Confidential, Virginia

Responsibilities:

• Responsible for Installing and Maintaining SQL server as required and configuration of SQL server services and TCP/IP protocols.
• Setup and scheduled full and transactional log backups for the user created and system database in the production environment using the Database maintenance plan wizard.
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
• Checking up scheduled jobs are running created through maintenance plan especially backup, Database Integrity and index fragmentation.
• Perform DBCC commands to troubleshoot issues related to database consistency.
• Involved in capacity planning, sizing and database growth projections.
• Performing query optimizations and query execution plans.
• Implemented views to facilitate user interface and triggers to enforce Data and referential integrity.
• Implemented indexed views to increase the query performance.
• Solving the issue based on user complains regarding slow performance issues.
• Tracing events on SQL Profiler and running it on Database tuning advisor.
• Maintain database level security by creating the Windows and SQL logins with the appropriate server/database roles and object level permissions.
• Administrating Multi Server agent job.
• Provide high - availability Solutions & Configurations - Log Shipping, Database Mirroring, Transactional Replication.
• Resolve locking /blocking conflicts and resource utilization.
• Managing Update with latest service packs and security patches.
• Upgrading Microsoft SQL Server from .
• Handle SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Reviewing DB Scripts from the development team before releasing them into the Production.
• Provide 7 x 24 Production support for the database and application issues.

Environment: MSSQLServer 2014, 2012, 2008, SSMS, SSRS, SSIS, Windows Server2012, 2008, ASP.NET/Java Applications, Visual Studio.

SQL DBA

Confidential, Atlanta, GA

Environment: Windows 2000, MSSQLServer 2000,SQL, T-SQL,SQLQuery Analyzer, Profiler.

Responsibilities:

• Database Administration, System Analysis and administration, Design, Development & Support of MS SQL Servers 2012, 2005, 2000 in Production, QA, Development & Replication Environments.
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back - up/recovery, running Database Consistency Checks using DBCC.
• Expertise in migrating of SQL Server databases from SQL 2000 to SQL 2005 and SQL2008. Also from SQL 2005 to SQL2008 R2, SQL 2008R2 to SQL 2012 including consolidating.
• Experience working with Production (24 x 7) and Development environment.
• Exposure in writing TSQL, Stored procedures.
• Experience in Reporting services in SQL Server 2008R2.
• Expertise in performance tuning, high scalability and availability using Cluster environments.
• Good Exposure to OLTP and OLAP environments.
• Configured, Installed and Monitored MS SQL Servers for Active - Passive, Active - Active on Microsoft NT Clustered Servers and Virtual Servers.
• Experience with Database Backup, Recovery and Disaster recovery procedures.
• Setting up DR solutions using Log shipping, Replication, Mirroring, Always On (2012) basing on RTO and RPO
• Experience in Supporting Huge Databases, Troubleshooting the problems.
• Excellent interpersonal, analytical and communication skills.

SQL Server Developer/DBA.

Confidential

Environment: MS SQL Server 2000/2005/2008 R2, Windows Server 2000, SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Maintenance Wizard, DTS, VB Script, IIS Web Server, MS Excel, and MS Access.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side-by-side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps needs to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
• 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
• Memory Configuration for SQL server on 32-bit boxes.
• Created various jobs to check health of the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, and triggers.

Jr. MS SQLServer Developer.

Confidential

Environment: SQLServer 2000, Query Analyzer,SQLProfiler, Windows 2000 Server, Import & Export Data.

Responsibilities:

• Installation, configuration the MS SQL Server 2000 and maintenance of servers in various environments.
• Monitoring SQL Services using MOM, SQL Sentry.
• Backups and Restore using Litespeed for SQL Server.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.