SUMMARY

• Around 9 years of experience in SQL Server Administration, Development and Database Design in Production, Development and Test environments with Microsoft SQL SERVER 2000,2005,2008,2008R2,2012 & 2014.
• Experience working with 32bit, 64 - bit MS SQL Server in Clustered and Standalone Server Environment.
• 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).
• Experience installing MS SQL Server 2000, 2005, 2008, 2008R2, 2012, & 2014; updating with hot fixes and service packs.
• Implemented new SQL Server 2012 technique ALWAYS ON for High Availability.
• Implemented In-place and Side by Side Migration of MS SQL Server 2000/ .
• Experience working with Azure SQL Database Import and Export Service.
• Extensive experience in implementing Clustering and mirroring on physical and virtual machines.
• Expertise in Database Administration on Production Servers with server configuration, Performance Tuning and maintenance with outstanding troubleshooting capabilities.
• Experience working in both OLTP and OLAP environments.
• Experience working with data-tier application (DAC) for Migration.
• Experience in deploying SQL Databases in CLOUD (AZURE & AMAZON).
• Experience in gap identification and controls improvement process by using SOX.
• Experience in Database designing, RDBMS, and Normalization/De-normalization.
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCCchecks and Update Statistics to check Data Integrity.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Knowledge of unix ODBC
• Knowledge of Informix and Informix ESQL/C .
• Experience in Migrating from Informix to SQL server.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Experience working with SQL Server 2014.
• Good at SQL Server 2008 new features like Policy Based Management, CDC, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Expert in Data Integrity, Performance Tuning and Query Optimization.
• Expertise in implementing Business logic by using T-SQL (DDL, DML, DCL)and User Defined Functions (UDF).
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL Joins and query writing.
• Experience in Error handling through TRY-CATCH statement, Common Table Expression.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in using the DMV’S, DMF’S, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups) and Restoring on requirement.
• Experience in handling the Isolation Levels and Concurrency Effects.
• Good knowledge about Database Recovery models.
• Experience in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans.
• Experience working with data-tier application (DAC) for Migration.
• Experience working with Active Directory Groups.
• Extensively worked on Hot, Warm and Cold Backups, Security Management, Managing server and client Connections.
• Experience in daily database maintenance and administrative tasks like Space issues, Transaction log file size growth, Connectivity issues and regular monitoring of SQL Server error logs and windows event viewer.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Involved in SQL server default port number changing to nonstandard port number, Created Server aliases as part of SQL Server hardening.
• Experience in using third party tools, for Data modeling SQL Diagrams Erwin, for Backup Solutions SQL Lite Speed, Red gate for performance and for alerting Idera.
• Auditing of database for users transaction, login and database action and removing orphan users.
• Worked with a team of business analysts, data architects, application developers and ETL developers and Testers.
• 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 creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Expert in creating SQL Server Reports using SSRS 2008.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation.
• Extensive experience in the development of Reports using SQLServer2000/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Crystal Reports, Matrix Reports, and Drilldown Reports in multiple formats using multi - dimensional objects.
• Strong ability in Scheduling and deploying reports on Report manger.
• Experience working with change control process.
• Expert in using MS Office suite 2007 including MS Access.
• Experience in Analysis Services (SSAS) OLAP Cubes, Star Schema and Snow Flake Schema, ETL and Data Warehousing. worked with ITIL management both in service support and service deleivery.
• Provided support for 24x7 availability of database Services.
• Zeal in self-learning latest versions of SQL Server and upcoming technologies from Microsoft.
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/ 2005/2008/2008 R2/2012/2014 & MS Access.

Programming Languages: T-SQL, C/C++, VB.NET, XML, Windows scripting & Power shell.

Operating Systems: Windows 2008 R2/2008/2003 R2/2003/XP/Vista/7, Unix (Sun Solar), Linux.

SQL Server Tools: SSMS, Configuration Manager, Performance Tools & SQL Profiler.

BI Tools: SSIS, SSAS and SSRS.

DB Utilities: SQL Server Management Utility, Query Analyzer.

Application Software: Microsoft Visual Studio 2005/2008/2010/2012/2013 , Visual Source Safe, MS Office Suite.

Third party Tools: Microsoft Visio, Erwin, Red gate, Lite Speed.

Other Tools: IBMSPSS Modeler, Microsoft products (Word, Excel, Power Point, Outlook), Adobe Photoshop and Adobe Light room.

PROFESSIONAL EXPERIENCE

Confidential, BOWIE MD

Sr. SQL Server DBA

Responsibilities:

• Installed MS SQL Server 2005, 2008 R2, 2012, updating with latest service packs and security patches.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Created data sets and used PROC SQL to perform various data Analysis in SAS.
• Designed various Slowly Changing Dimensions.
• Worked extensive with database design team and development team for database design and implementation, used Erwin and Visio for database design and SQL 2008 for development.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented the Data Partitioning for large tables in SQL Sever 2008.
• Created custom log-shipping to manage Disaster Recovery and Production Support restores
• Administered SQL Server 2012 Always on technology.
• Scheduling the DBCC commands to run daily, weekly basis. Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification .
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Worked file and file group Backup/Restore.
• Maintained the database consistency with DBCC at regular intervals
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in logical designing and physical designing the databases using ERWIN.
• Performing DB Security, creating users, roles, and assigning permission to them.
• Worked on SQL server 2008 T-SQL new features such as MERGE statement and Date time offset Data type.
• Experience in Database migration, integration and version up-gradation.
• Expert in understanding of Enterprise Security model in SQL server .
• Experienced in Designing databases and Data modeling.
• Extensively worked on Backup procedures, error handling, query optimizations and performance tuning.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Extensively worked on SQL Server Integration Services (SSIS) and also worked on SSIS package deployment and security of SSIS packages.
• Administered and authored SSRS reports.
• Implemented new topics like CLR integration on Development server.
• Solving the Bugs Reflected by the Testing team.
• Used Performance Monitor/SQL Profiler to analyze long running /slow queries and tune the same to optimize application and system performance.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Worked on different third party tools like Spotlight and Red gate.
• Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.
• Created Logon trigger to validate users connecting through different applications.
• Supporting 24/7 Production Environment.

Environment: MS SQL server 2000/2005/2008/2012 , Windows 2000/2003, VB, .Net, Enterprise manager, Query Analyzer, DTS, SQL profiler

Confidential, Austin, TX

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008/2008 R2 on the server and client machines, provide connections and manage databases.
• Created and maintained various databases for Production, Development Servers using MS SQL Server 2005/2008/2008 R2.
• Planning the location of data, indexes, and Transaction log files on the disk.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Resolved locking and blocking issues.
• Tuning the Production server to get the performance improvement.
• Running Index tuning wizard for optimal query performance.
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
• Experience working with IDERA for Performance Monitoring, Dead Lock, and Blocking.
• Monitoring SQL Server Logs, Application logs and analyzing the logs.
• Provided 24/7 support to SQL application developers in implementing them production server.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created the SSIS packages for executing the tasks, created the Jobs and scheduled for daily running.
• Involved in Change Data Capture process.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, production support and Project review with client.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.
• To design & develop data models and perform forward and reverse engineering using data modeling tools like ERWIN.

Environment: SSQL Server 2005/2008/2008 R2/2012 with clustering, Sybase, T-SQL, LiteSpeed, Windows 2000, Oracle, VB and ASP.

Confidential, St Louis, MO

SQL Database Administrator

Responsibilities:

• SQL Server bit Failover Cluster Installation on Windows Server bit.
• SQL Server 2008 Installation.
• Writing batch scripts to do automation of database tasks.
• Writing scripts to manage different servers for auditing purpose.
• Running packages as for system promotion requirements.
• Solving Memory Problem related with SSIS Packages.
• SQL Server Analysis Services 2000 installation and Reporting Services 2005
• Installations on existing SQL Server Instances and SQL Server 2005 installations.
• Performance tuning on different Production Servers.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Running profiler to troubleshoot Blocking issues, Deadlocks issues and Slow running Queries.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Solving memory related problems by changing server configuration settings.
• Building Maintenance plans for database maintenance.
• Writing stored procedures as for business requirements.
• Backup and Restore databases.
• Moving Tempdb to different file location.
• Shrinking the LOG files as the space requirements.
• Managing users and security.
• Managing schema objects, such as tables, indexes, and views.
• Making database backups and performing recovery when necessary.
• Used Team Foundation Server 2010 for maintaining source control, data collection, reporting, and project tracking
• Creating Database maintenance plans for compressed full DB backup and transaction log backup, Check Database Integrity, Index maintenance and update statistics.
• Managing Security like windows/Unix, Oracle and SQL Logins, Roles, permissions for various users.
• Involved in Configuration and Administration of Share Point 2007 environment.
• Resolve Database, query performance, Log file full and Low disk space issues.
• Monitoring alerts, creating tickets with remedy/ETMS/SDP ticketing tools according to severity of the alerts
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2000/2005, T-SQL, Windows 2003/2008 Server, Team Foundation Server 2010, Oracle 10g,Vb.net,Asp.net.

Confidential

DBA/Developer

Responsibilities:

• SQL Server 2005 Database Administration and maintained all production, non-production databases and DR environments including development, Integration testing, UAT and trouble shooted SQL Server 2005/00 systems and disaster recovery site.
• Configured and Monitored disaster recovery environments Log shipping/ Transactional Replication and trouble shooting of errors.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB).
• Monitoring the SQL server performance with SQLDIAG and testing the production server data load and I/O stress.
• Migration of SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration.
• Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
• Loading flat files into Oracle Database using SQL*Loader.
• Developed stored procedures/Packages using T-SQL to meet the business requirements.
• Performed backup and recovery strategies using cold backup/hot backup/RMAN for oracle databases and Redgate for SQL Server databases on clustered environment.
• Extensively worked on DTA, DMV’s, DMF's, online indexing, Data partitioning and tuning of long running stored procs and complex queries.
• Performed day-to-day tasks like monitoring jobs, Alerts, SQL Server Error logs, Event logs, Disk spaces, Alert logs and SQL auditing including backup and restore.
• Analyzed long running queries and tuned the same to optimize application and system performance.

Environment: SQL Server 2005/2000, Oracle 9i/10g, DB2UDB,TERADATA, Linux, Window Server 2003, VSS, SQL profiler, Perfmon, T-SQL, SQL, PL/SQL, RMAN, TOAD, OEM, SQL*Loader, TSM, Litespeed, Spotlight, SSIS, SSRS, SSAS, ERWIN, Power designer, XML, XSLT, VB.NET, ASP.NET.

Confidential

SQL DBA/Developer

Responsibilities:

• Installing, configuring, administering and securing production and non-production servers. Installed and configured SQL Server 2005 on the server and client machines, provide connections and manage databases.
• Created and maintained various databases for Production, Development Servers using MS SQL Server 2005
• Involved in complete SDLC which includes requirement gathering, analysis, design, development, Implementation.
• Implemented and maintained database security.
• Involved in capacity planning and sizing for new database servers.
• Migrated MS-access databases to SQL Server 7.0 databases.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Creating Database maintenance plans for compressed full DB backup and transaction log backup, Check Database Integrity, Index maintenance and update statistics
• Trouble shooted and minimized production down issues.
• Created T-SQL packages, procedures, functions, triggers, alerts, scripts for automation and DTS packages for ETL.
• Developed Transact-SQL scripts to enforce business rules.
• Monitoring of alert log files, control files, archive log destinations, blocking, deadlock issues and long running complex queries/stored procs.
• Export and Import of database objects to copy from one database to another database.
• Designed new job process, new database maintenance plans, DTS packages.
• Resolved failed and long running MS SQL Server jobs.

Environment: SQL Server 7.0/2000, Oracle 8i, Ms-Access, SQL, Enterprise Manager, Query Analyzer, Windows 2003/2000, Linux, PL/SQL