SUMMARY

• 7+ years of experience in supporting Very Large databases (VLDB) and good experience with complex databases.
• Intensive experience in monitoring database performance using SQL Profiler.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query.
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering.
• Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Involved in Authoring, deploying, delivering of reports using SSRS.
• Expertise in ITIL Process Creation and management.
• Expertise in Change, release, incident and configuration management.
• Extensive experience as a SQL/DB2 DBA and good experience as an Oracle DBA.
• Expertise in Always on Availability Groups(AAG) and HA/DR Troubleshooting.
• Hands on experience with Shell scripting.
• Performed Migration across cross platforms.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• 24/7 Production Database on Call Support.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, Windows

Programming Languages: Java, C, C++, C#.Net on IIS, Flex 3.

Web Technologies: HTML, CSS, Servlets, JSP, JavaScript, ASP.

Database: DB 2 9.5/9.7/10.1 , SQL Server 2012/2008/2005 , MYSQL, PL/SQL, Oracle 10g/11g

Networking: IPV4, IPV6, TCP, HTTP, DNS

Tools: Quest Central, Ignite, Toad, Flex Builder 3, Visual Studio 2005/2008, Adobe Dream Weaver, SQL* Plus, SQL* Loader, SQL Developer.

Methodologies: UML, Model driven, Agile and Scrum.

IDES: Eclipse, NetBeans, My Eclipse.

PROFESSIONAL EXPERIENCE

Confidential - Austin, TX

Sr. MS SQL Server DBA

Responsibilities:

• Migrated over 500 databases from the HPI domain to the HPE domain.
• Managed the servers that were under VERITAS clustering environment.
• Worked with the development team on query optimization for better performance of the databases.
• Updating Apate (database repository for all the HPI databases) with the new connection string details.
• Resolving all kinds of performance issues after the migration is done which include setting up the maintenance jobs as well.
• Involved in major production issues and provided the client with root cause analysis.
• Configured Log shipping on a couple of production servers and performed role reversal of the primary and the secondary log shipped database.
• Experience in Database backups RMAN (Full/Incremental backups) and hot/cold backups.
• Experience in Oracle10g/11g RAC implementation and administration
• Provided the client with disk space estimates, database sizes on all the servers so that additional SAN can be added if required to accommodate the databases.
• Participate in client meetings to give the status update on the project.
• Prepared technical documentation for the migration activity.
• Extensively worked on change, release, incident and configuration management.
• Created more than 200 RFC’s as part of the DB migration process.
• On call support.

Environment: Windows 2003/2008/2012 , SQL server 2012/2014, Oracle 10g/11g

Confidential, Columbus, OH

MS SQL Server DBA

Responsibilities:

• Involved in upgrading of several SQL servers from .
• Managed the clustering environment.
• Extensively used SSIS packages.
• Responsible for monitoring daily jobs like dbcc checks, Re indexing.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs
• Fine-tuned databases as a part of performance tuning.
• Monitored databases using Ignite.
• Involved in Data archiving and purging process as a part of maintenance.
• Prepared technical documentation for projects.
• Suggested better strategies to avoid slow performance of the database.

Environment: Windows 2003/2008/2012 , SQL server 2008/2 .

Confidential, Columbus, Ohio

SQL DBA

Responsibilities:

• Installation and maintaining of SQL server databases which includes monitoring success/failure of automated jobs, resolving system issues
• Experience in generating periodic reports using SSRS
• Relocation of databases from one server to another using Attach and Detach
• Created SSIS packages using Import/Export Wizard.
• Rebuilding the indexes at regular intervals for better performance
• Maintaining the database consistency with dbcc checks at regular intervals.
• Worked on scripts to schedule backup jobs, daily/weekly jobs.
• Implemented high availability solutions like Always On, Log shipping, clustering, mirroring.
• Scheduled the backup and restore jobs through maintenance plans as well as manually
• Monitoring SQL server performance using profiler.
• Proficient in writing stored procedures, packages and triggers.
• 24x7 on call support
• Extensive experience with Incident, problem and change managements.
• Performed migration of databases from SLES to Red hat Linux Servers
• Database backup/recovery of databases including redirected restore
• Run reorgs and run stats to maintain performance of the databases
• Use event monitors db2pd, db2explain and snapshots to monitor and tune the database performance
• Extensively used utilities like Load, Import, Export to load data
• Upgraded databases from version 9.7 to 10.1
• Efficiently used vmstat, db2pd, db2top utilities to troubleshoot performance related issues with databases
• DB2 LUW installations and Fix packs on Linux and AIX
• Monitor database and support development of new releases
• Involved in RCA efforts for outages and worked efficiently with IBM
• Written scripts to alert the team of any trap files filling up the file system to avoid outages
• Implemented HADR on a TSA domain, performed replication.
• Performed production recycle activities and power down activities
• 24x7 on call support
• Worked efficiently with the system administrator for capacity planning and storage management.

Environment: DB 2 9.5/9.7/10.1 , SQL server 2008/2012/2014 , Windows 2003/2008

Confidential, Milwaukee, WI

MS SQL Server DBA

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes.
• Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R2
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so creates reports that draw content from a variety of data sources.
• Implemented MS SQL Server security policies and granted object level permissions.
• Created jobs for rebuilding of indexes and updating statistics.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Configured Transactional replication between Primary Server and three Read-Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Performance Monitoring of MS SQL Server 2005/2008.

Environment: Windows 2003/2008, MS SQL Server 2000/2005/2008/2012.

Confidential, Charlotte, NC

MS SQL Server DBA

Responsibilities:

• Served as a SQL Server DBA and P.O.C for an E-ordering Application.
• Responsible for maintaining High availability servers like Clustering and transactional Replication.
• Responsible for solving application related issues in all environments (Dev, Staging, production) like query timeouts.
• Handled issues in Replication like Replication Agents Failure, Subscription failure etc.
• Involved in Migration from SQL Server 2005 to SQL Server 2008.
• Involved in migrating several DTS packages to SSIS Packages.
• Responsible for Performance tuning like optimizing stored procedures which involves re-writing some portion of code per business and adding some indexes to base tables etc.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions
• Responsible for monitoring and making recommendations for performance improvement in hosted Databases. This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases.
• Implemented Data Partitioning Strategy for Better performance.
• Responsible for Monitoring Daily running jobs like Data Loading jobs, Replication jobs.
• Responsible for trouble shooting failed jobs and Replication Related issues etc.
• Suggested better scheduling strategy for jobs to overcome blocking and dead locks.
• Involved in Data archiving and purging process as a part of maintenance.
• Traced long running queries and Stored Procs using SQL Profiler to tune them as a part of Application enhancement.
• Used Index tuning wizard for Tuning of indexes.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages to automate several tasks.
• Responsible for Deploying Code changes, code review and Code Releases in all Environments with respect to release deadlines.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
• Maintain transactional replication on production SQL Servers.
• Set up transactional, snapshot replication and maintain the active replication(s).
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Performed daily backup and created named backup devices to back up the servers regularly.

Environment: SQL Server 2008, SQL Server 2005/2000 Enterprise Edition, SSIS, Windows Server

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server 2005/2008.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005/2008.
• Implementing Load Balancing Replication across the Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of the SQL Server for Web based Production and Development environments.
• Used Perf Mon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs
• Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000/2005/2008 Windows NT/2003, VERITAS Net Backup and Crystal Reports.

Confidential

MS SQL Server DBA

Responsibilities:

• Handled up to 2 TB Size databases with clustered and replication environment
• Relocation of Databases from one server to another server using attach and detach databases.
• Migrated of databases from SQL Server 2000 to SQL Server 2005.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Wrote the packages using SSIS IN SQL 2005
• Developed, deployed and monitored SSIS Packages.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.
• Rebuilding the indexes at regular intervals for better performance
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitoring the servers using Idera third party software.
• Maintaining the database consistency with DBCC at regular intervals
• Used DTS packages to move logins and jobs from one server to another server.
• Expertise in SQL Server Reporting Services(SSRS)
• Monitoring SQL server performance using profiler to find performance and dead locks.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• 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.
• Prepared the project management and technical documentation.

Environment: SQL Server Enterprise, Windows Enterprise Server, IIS 6.0, .NET, ASP, Microsoft Visio 2003

Confidential

Mentorship / Programmer Analyst

Responsibilities:

• Responsible for building and maintaining the required backend DB2 database “OILTRACK” using IBM DB2 software along with other 3 DBA s
• Created the required instance, database, buffer pools, Table spaces and tables.
• Created Cron job scheduler on the instance and schedule daily, Incremental and Delta backups.
• Created run stats and table reorgs, analyzed the database for performance metrics and data growth.

Environment: DB2, SQL, Linux and control center.