SUMMARY:

• Having 10+ Y ears IT experience in Database Administration, Design Development and Support of MS SQL Server 2012/2008R2/2005/2000 in Production, Test, Development and Cluster Server Environments.
• Experienced in managing very large production Databases.
• In depth knowledge in SQL Server backup and recovery. Can plan effective backup strategy as per the environment needs.
• Planning and implementing disaster recovery procedures to ensure minimal downtime and data loss
• Responsible for ensuring availability and performance of the databases.
• Ability to write scripts as per the environment for DBA monitoring purposes and data collection purposes.
• Creation of database maintenance plans, rebuild/defrag indexes, database consistency checks.
• Migrated databases from SQL Server, 2008R2 to 2012.
• Implementation of Database Mirroring, Log Shipping, Replication.
• Experience in configuring log - shipping and supporting the log shipped databases.
• Managing Security (Creating users, logins and roles, granting permissions).
• Experience in configuring Database Mirroring and ensuring high Availability to the databases by testing the failover.
• Maintaining High Availability of Databases using Mirroring concepts.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003, Windows 2000 Server/ Advanced Server, Windows 98/XP/Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSISWeb Technologies: XML, HTML, VBScript

GUI Tools: Visual Studio (VB), Visual Studio2005/2003

Languages: VB 6.0, VB.Net, T-SQL.Net Technologies: VB. NET, ASP.NET

Web Server: Internet Information Server

Databases: SQL Server 2012/2008R 2/2008/2005/2000, MS Access, Oracle 9i.10g, 11g

Version Tool: Visual Source Safe

Reporting Tools: Business Objects, Crystal Reports OLAP Tools SQL Server Reporting Server 2008/2005, SSIS (as ETL)

ETL Tool: Informatica Power Center

Third Party Tools: Lite speed, Erwin, DB Moto.

PROFESSIONAL EXPERIENCE:

Confidential, Onsite Atlanta, GA

Sr MS SQL DBA

Responsibilities:

• Managing security on Production and Development environments.
• Monitoring the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2012/2008R 2/2005/2000.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Evaluate and Select COTS Solution(s)
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005/2008R2/2012.
• Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment.
• Implement the COTS based solution.
• Upgraded legacy 2000 databases to SQL server 2005/2008.
• Involved in Database Backup and recovery.
• Implemented high availability on the various servers using replication/mirroring/Clustering.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implementing and testing the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Created necessary templates for various requirements gathering and documentation.

Environment: Windows 2000/2003, MS SQL Server 2000/2005/2008/2012, Oracle10g/11g, SSRS, DTS, SSIS,BCP SQL Server Profiler, VB.NET, T-SQL, Erwin 4.0, Erwin 3.5.2,DBMoto, Database engine tuning Advisor, IIS.

Confidential

Production Support SQL DBA

Responsibilities:

• Database Administration of around 1200 MS SQL Servers of Malaysia, Prague & USA.
• Installation, configuration and upgrading of Microsoft SQL Server .
• Production DBA support for custom and COTS systems with MS SQL Server.
• Establish and maintain sound backup and recovery policies and procedures.
• Database tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Database migration was done for database from Production to Development and vice versa.
• Performing routine DBA tasks like maintaining Database Space Utilization and troubleshooting the DB and solving the Incidents.
• Data file addition and Migration of database from one disk to another.
• Planning and implementing disaster recovery procedures to ensure minimal downtime and data loss
• Implementing and administering various Database mirroring, Clustering, Replication and Log shipping environments.
• Backing and Restoring of Databases

Environment: MS Sql Servers, Windows Server 2008 SP2 Enterprise/Standard Edition

Confidential

Production Support SQL DBA

Responsibilities:

• Database Administration of around 1000 servers of APAC regions.
• Implementing and administering various Database mirroring, Clustering, Replication and Log shipping environments.
• Perform routine DBA tasks like maintaining Database Space Utilization and troubleshooting the DB and solving the Incidents.
• Database Maintenance Plan jobs were written in order to monitor the log files and Data files of the production databases.
• Production DBA support for custom and COTS systems with MS SQL Server.
• Backups & Restorations for 1000+ databases.
• Database migration was done for database from Production to Development and vice versa.
• Installation of SQL SERVER 2005, 2008 R2 & 2012.
• Upgrading database from SQL Server 2005 to SQL Server 2008R2, SQL Server 2008R2 to SQL Server 2012 .

Environment: MS Sql Servers, Windows Server 2008 SP2 Enterprise/Standard Edition

Confidential

Production Support SQL DBA

Responsibilities:

• Managing 500+ terabyte Databases of SQL Server 2005 & 2008 on various environments.
• Production DBA support for custom and COTS systems with MS SQL Server.
• Installation, Configuration and Patching of SQL Server for all versions.
• Involved in Planning, implementation and maintaining of different kinds of DR Plans like (Log shipping, Mirroring and Custom Log shipping).
• Involved in Database maintenance, Performance Tuning, Backup Recovery.
• Identifying and resolving Blocking and Deadlock issues by using Activity Monitor and Profiler.
• Maintenance activities using DBCC commands for maintaining optimum performance and managing the size of databases.
• Allocating, shrinking and altering the Database files.
• Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.
• Mapping information has retrieved by service provider in SAML 2.0 federation.
• Maintaining documentation for the complete environment.
• Responsible for migrating databases.
• Solving space issues like TempDB and Log file issues.

Environment: MS Sql Servers, Windows Server 2008 SP2 Enterprise/Standard Edition

Confidential, Richmond, VA

SQL DBA.

Responsibilities:

• Maintaining Backup and Restore Policies
• Monitoring the Scheduled job
• Executing DBCC as a part of Maintenance activities
• Identifying and Resolving Blocking issues
• Evaluated COTS components which are assessed with respect to user requirements using the appropriate techniques.
• Allocating, shrinking and Altering the Database files
• Maintain Database Security.
• Supported for XSL Formatting Objects.
• Maintained and developed Fail-Over databases using Database Mirroring
• Configuring and monitoring Replication.
• Encrypted information for service provider in SAML 2.0 federation.
• Establish procedure to migrate databases, logins, and jobs to new environment servers.
• SQL Server query tuning and optimization for various applications.

Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer.

Environment: MS Sql Servers, Windows Server 2003 Enterprise/Standard Edition

Confidential

SQL DBA.

Responsibilities:

• Maintaining the jobs Schedules and Backup and Restoration of Databases.
• Implementation of SQL logins, roles and authentication modes as part of security policies for various categories of users
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Regular data consistency checks.
• Maintained high availability of database using Log shipping and mirroring
• Migration of databases between the servers
• Designed the COTS package configuration requirements
• Scheduled Alerts and Jobs Using SQL Server Agent.
• Identifying and Resolving Blocking related issues
• Configuring and monitoring Replication.
• Worked XSL transformations.
• Created Adhoc Reports in SSRS.
• Monitoring SQL Server Performance and Activity
• Successfully migrated SQL Server 2000 databases to SQL Server 2005.
• Configured an ASP.NET 2.0 Web application to use role management.
• Create a daily report for all production servers.
• Worked with the world class news apps team to conceive, design, build, and deliver a set of robust APIs.
• Established procedure to migrate databases, logins, and jobs to new environment servers.

Environment: MS Sql Servers, Windows Server 2003 Enterprise/Standard Edition

Confidential, California

ETL Developer

Responsibilities:

• Used heterogeneous data sources like flat files and MS Sql Server 2000.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created and Monitored Informatica sessions.
• Worked in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Checked and tuned the performance of Informatica Mappings.
• Configured an ASP.NET 2.0 Web application to use role management.
• Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.
• Worked with the world class news apps team to conceive, design, build, and deliver a set of robust APIs.
• Analyzed Mappings and Sessions for better performance.

Environment: Informatica Power Center, Windows, Flat Files, MS Sql Server 2000.