SUMMARY

• Having 7+ years of experience in IT Industry as Database Administrator as well as database developer.
• Currently serving as Senior Database Administrator and leading a DBA team in Confidential .
• Architect, Design and Implement Microsoft SQL Server Enterprise wide database solutions, manage team of systems administrators and database professionals.
• Proficient in Microsoft Database technologies MS SQL Server databases (2012, 2008 R2/2008, 2005 and 2000).
• Extensive experience in installation and configuration of MS SQL Server 2012, 2008 R2/2005/2000 versions.
• Implemented and validated the Disaster Recovery for the warehouse solution and created a DR clone environment for Load testing needs.
• Experience in monitoring the DB performance with IGNITE Performance Monitoring tool.
• Expertise in planning and implementing MS SQL server security and database permissions.
• Hands on experience in handling huge databases and implementing appropriate backup and recovery strategies.
• Experience in configuring Windows Clustering services and SQL server clustering in SQL 2008 R2.
• Expert in implementing high availability techniques such as Log shipping and database mirroring and clustering.
• Good knowledge on SQL Server Replication.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks.
• Good exposure in developing SSIS and DTS packages.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
• Provided after hours and 24/7 database maintenance and support.
• Proven ability as a quick learner of new skills and technologies.

TECHNICAL SKILLS

Programming Languages: T - SQL, PL/SQL

Database Application Software: SQL Server 2008/2005/2000/7.0 , MS Access, Oracle.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

Reporting: MS Access, Excel, MS SQL Server Reporting Services 2000/2005, SSIS

ETL Tools: SSIS,DTS,SAS

Application Software: Microsoft Office, macros, Visual Studio.

Modeling Tool: ER-Win.

Operating Systems: Windows Vista/XP/NT/2000, Windows Server 2008 R2/2008/2003

PROFESSIONAL EXPERIENCE

Confidential, Raleigh NC

SQL server DBA

Responsibilities:

• Worked closely with various teams at client location to gather and understand the database requirement setting up of new MSSQL Server 2012, 2008 R2 and 2005 databases in both development and production environments.
• Worked on design & placement of database suitable to database usage and criticality and was involved in different database placement processes which include requirement collection and finding the place with matching requirements.
• Attending weekly production support status meetings with clients.
• Provide MS SQL Server DB administration and maintenance activities.
• Ensure maximum availability of application by monitoring daily database and server check.
• Provide support to maintain databases for application development groups (create new database structures, load/ unload data and backups plans) and in corporate changes required by the application to the databases.
• Performance tuning of the database regions like stored procedure and T-SQL having high response time(s), monitor and advise on performance related factors of existing/new applications while working to move these same applications towards being available 24x7.
• Automation of Space Management, Performance metrics and Security Audit using T-SQL queries and analyzing DB growth.
• Database backup and restore and providing fixes to production problems.
• Maintained the database environment security by identifying minimal access requirement for different users and provided alternative solutions to do the task without violating company policy.
• Installed, configured and monitored Active/Active clustered servers.
• Created and maintained database security, logins, users, roles and user permissions.
• Creating the complex stored procedures, user defined functions to meet the business rules.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Developed High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) and c# scripts.
• Responsible for creating the reports using the SQL server reporting services and maintained them. Used the various parameter passing techniques to create input for reporting parameters.
• Developed User Interactive Sheets & Reports as per business needs in SSRS.
• Performance tuning and optimization of the Stored Procedures and Queries with slow performance.
• Improved the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Developed and maintained maintenance plans, evaluated scheduled jobs and monitored performance during various job runs.
• Going through the clients' requirements and coming up with database design and application architecture.
• Actively participated in gathering and analyzing Business Requirements, Creating Directives, Data Analysis, Design, Development, Conversion, System Testing, Operational Readiness, Documentation, Production support issues.

Environment: Windows Server 2008/2008 R2, SQL Server2008R2/2012, IIS 6.0, SQL Server Integration Services (SSIS)

Confidential, St. Louis

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Servers on various environments.
• Maintained Development databases, QA databases and Applying Patches
• Cloned Prod to Dev and QA and test Data warehouse DB’s
• Efficiently use the Snap Manager for SQL Server to clone and take regular backups.
• Create the environment for the Data Warehouse team for developing the reports using MS BI.
• Managing scheduled tasks for the servers and also automating all the maintenance activities and data flow tasks.
• Written Database Packages, Procedures, Functions and Triggers.
• Developed Scripts for refreshing Development and QA databases.
• Creation and Maintenance of Standby Database.
• Looked into day-to-day activities of Production database, Monitoring its growth and performance.
• Auditing user actions in the database.
• Coordinating with the front-end team and Data warehouse team & full fill their database requirements.
• Deployment of structures and scripts from test to QA and QA to Production.

Environment: Windows Server 2008/2008 R2, SQL Server2008/2008R2, IIS 6.0, SQL Server Integration Services (SSIS)

Confidential, St. Louis

SQL Server DBA

Responsibilities:

• Installed SQL Server and applied service packs and hot fixes on a routing basis
• Was involved in requirement analysis and capacity planning for database design, maintenance
• Running DBCC consistency checks, and fixing data corruption in application databases
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Maintain disaster recovery strategies for the database and failover methods.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Worked on importing data from MS-Access Database and XML to SQL Server Database. Worked with development teams in the design of physical databases and in modification.
• Installed and configured Microsoft SQL Server 2008R2 on production and development servers in physical and virtual servers running on VMware.
• Expertise in planning and implementing SQL server Security and database permissions, creating roles and managing user permissions
• Created Triggers to enforce data and referential integrity.
• Creating the complex stored procedures, user defined functions to meet the business rules.
• Planned and co-coordinated database security measures.
• Implemented database mirroring
• Configured various database replication topologies.
• Installed, configured and monitored Active/Active clustered servers created and maintained database security, logins, users, roles and user permissions.
• Worked on performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan..
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP and BULK INSERT.

Environment: Windows Server 2008/2008 R2, SQL Server2008/2008R2, IIS 6.0, SQL Server Integration Services (SSIS)

Confidential

SQL Server DBA

Responsibilities:

• Installation and configuration of SQL Servers on various environments.
• Administration of database servers that included more than 20 High end DB servers including five failover clusters.
• Design and Development of the databases and database objects.
• Database performance and efficiency.
• Deployment of database structures in production environment.
• Import Export of data using DTS, SSIS.
• Coordinating implementation of performance and tuning actions with application development teams
• Analyzing and implementing requested modifications to existing database structures for change requests. Managing scheduled tasks for the servers and also automating all the maintenance activities and data flow tasks.
• Preparation of Technical documents.

Environment: Windows Server 2003/2008, SQL Server2005/2008, IIS 6.0, SQL Server Integration Services (SSIS)

Confidential

SQL Server DBA

Responsibilities:

• Preparing a suitable migration plan according to the requirements.
• Doing initial POC and testing before taking the actual plan forward.
• Identifying the data structures and order of activity to move the structures within minimal downtime.
• Implementing the actual migration and making post migration checks.
• Monitoring the performance and post migration issues.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: Windows Server 2003/2008, SQL Server2005/2008, IIS 6.0, SQL Server Integration Services (SSIS)

Confidential

SQL Server DBA

Responsibilities:

• Preparing a plan for collection of data from the external systems and modulate it in the format required for our applications.
• Designing database objects (stored procedures and functions) to provide applications specific data as per their requirements.
• Creation of schedulers to pick the master data on regular intervals.
• Monitoring jobs picking the incremental data and troubleshooting any failures.

Environment: Windows Server 2003/XP, SQL Server2000/2005, IIS 6.0, SQL Server Integration Services (SSIS)

Confidential

SQL Server DBA

Responsibilities:

• Creating databases, maintenance plans, back up strategy, jobs etc.
• Data push from the old database schema to new schema.
• Converting DTS to SSIS packages and rebuilding new SSIS where ever it’s applicable.
• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.
• Providing the requisite permissions to the database users.
• Maintaining the statistics of the database sizes and their growth for future scalability as a part of space management.

Environment: Windows Server 2003/XP, SQL Server2000/2005, IIS 6.0, SQL Server Integration Services (SSIS)