PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Lead SQL Server/ Sybase DBA

Responsibilities:

• Functional Focus team Lead for SQL Server.
• Standardize the SQL Server DBA process, best practices and documents for all teams.
• Performed Lead DBA role in Data Center Migration activities of 100+ SQL Servers from Berkley Heights NJ to Conway AR.
• Provided 24x7 Remote on - call support for SQL Server and Sybase
• Installed and Configured SQL Server 2005 and SQL Server 2008/R2 Standalone and Cluster servers on Windows 2003 R2 /2008/R2 servers.
• Upgraded SQL server 2000/2005 databases to SQL Server 2008/R2.
• Work on Requests through Unicenter ServiceDesk ticketing tools.
• Setup of Replication, Trouble shooting the issues related to it.
• Performed SQL Server emergency recovery.
• Created and managed databases in production and development servers.
• Managing user security/permissions.
• Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
• Involved in installation and configuration of SQL server 2000
• Perform database maintenance - Backups/restores using SQL Litespeed, Index tuning.
• Proactive monitoring of space usage and effective capacity planning.
• Experience in working with Reporting Services to manage reports for organizations.
• Optimizing stored procedures, Views and defining guidelines for developers.
• Prepare and maintain SOX Auditing.
• Responsible for General Database Administration and Performance tuning.
• Troubleshoot SQL Server issues related to Datacenter migration.
• Involved in upgradation of Sybase IQ from 12.6 to 15.3
• Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
• Perform weekly Sybase IQ maintenance tasks.
• Apply patches/Service packs to SQL Server
• Conduct Interviews for new DBA position.

Environment: SQL Server 2000/2005/2008 / R2, Win 2003, Win 2008 /R2 Servers, SQL LiteSpeed, Windows Cluster Sybase 12.*, 15.*, HP UNIX, Powershell.

Confidential, Manhattan, NY

SQL Server DBA

Responsibilities:

• Primary DBA for 20 applications and 35 SQL Servers.
• Provided 24x7 Remote on-call supports.
• Installed and Configured SQL Server 2008 and SQL Server 2005.
• Upgraded SQL server 2005 databases to SQL Server 2008 and SQL Server 2000 databases to SQL Server 2005.
• Performed SQL Server emergency recovery.
• Installed and Configured 64 Bit SQL Server 2005 active\active cluster instances.
• Designed and Implemented end to end activities of Data center move for SQL server from Leonia to Atlanta.
• Work on Requests through ITSM ticketing tools.
• Setup of Log shipping, troubleshooting the issues related to it.
• Created and managed databases in production and development servers.
• Managing user security/permissions.
• Perform database maintenance - Backups/restores using Tivoli (TSM), Index tuning.
• Proactive monitoring of space usage and effective capacity planning.
• Responsible for General Database Administration and Performance tuning.
• Troubleshoot SQL Server issues related to Datacenter migration.
• Install, configure and upgrade MS SQL Server.
• Optimizing stored procedures, Views and defining guidelines for developers.
• Setting up of Transactional Replication to remote servers.
• Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
• Implemented DR tests from 3rd party DR site(IBM at Sterling forest NY)
• Enhanced the existing SOX Reports to eliminate hidden privileges to users.
• Troubleshoot SQL Server connectivity issues using protocols.
• Experience in working with Reporting Services to manage reports for organizations.
• Enhanced the existing DR model by renaming the virtual name of DR server to match Production server.
• Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.

Environment: SQL Server 2000/2005/2008, Win 2003 Servers, SQL LiteSpeed, Windows Cluster, Idera, Foglight

Confidential, Raritan, NJ

SQL Server DBA and Offshore Mentor

Responsibilities:

• Primary DBA for 40+ applications and 150 SQL Servers.
• Provide transition of new applications to our team.
• Performed SQL Server emergency recovery.
• Do initial planning and provide requirement of hardware specifications to application team.
• Consolidate small\ mid size databases to our shared form servers.
• Test and prepare documentation of new hot fix\ service packs.
• Work on escalations from offshore team.
• Installed SQL Server on Windows 2000 Server
• Provided 24x7 Remote on-call supports.
• Escalation to Microsoft on critical issues on Production servers.
• Automated reports to list non-compliance objects for SOX servers.
• Experience in working with Reporting Services to manage reports for organizations.
• Installed and Configured 64 Bit SQL Server 2005 active\active cluster instances.
• Upgraded SQL Server 2000 databases to SQL Server 2005.
• Work on Requests through ITSM ticketing tools.
• Perform database maintenance - Backups/restores, Index tuning.
• Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
• Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
• Creation & monitoring of replication and troubleshooting it in case of failure
• Proactive monitoring of space usage and effective capacity planning.
• Monitored and Tuned SQL Performance using SQL Profiler.
• Troubleshoot SQL Server issues related to Datacenter migration.
• Optimizing stored procedures, Views and defining guidelines for developers.
• Responsible for General Database Administration and Performance tuning.
• Involved in DRP activities
• Represent SQL team in change control meetings.

Environment: MS SQL Server 2000 / 2005, Win 2003 Servers, SQL LiteSpeed, and Windows Cluster

Confidential

Project Lead

Responsibilities:

• Worked in UK for 7 months.
• Managing Huge databases of over 2 T.B
• Involved in end to end activities of migrating SQL Server Databases from a newly acquired company (Mortgages) into Merrill lynch Data Center environment.
• Managing over 250 Production servers and 500 Dev and UAT servers.
• Upgrade of Databases from SQL Server 2000 to SQL Server 2005.
• Built 2, 3 and 4 node clusters. Built 2 instances of SQL Server 2005 on x64 2 node cluster.
• Responsible for General Database Administration and Performance tuning.
• Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
• Configured Active Directories, SQL Server Database, Farms and various Servers within a farm.
• Setting up of Escalations to Production and Development SQL Servers.
• Expertise in Performance tuning using precise 7.5.
• Setting up of Transactional Replication to remote servers.
• Expertise in Scheduling SQL jobs through Autosys.
• Rolling out of changes in production environment through change control.
• Troubleshoot SQL Server issues related to Datacenter migration.
• Experience in working with Reporting Services to manage reports for organizations.
• Expertise in scheduling and restoring of flat file backups from Legato and Tivoli storage manager.
• Install, configure and upgrade MS SQL Server.
• Work on requests and alerts through Ticketing tool
• Performed SQL Server emergency recovery.
• Conduct technical interview for recruiting new member into team
• Responsible for providing Knowledge Transfer to new team members
• Responsible for providing training on new process and technologies
• Handling day to day issues from client with related to offshore team.
• Preparing RCA incase of any issues done by my team.
• Awarded best DBA in this Project.

Environment: SQL Server 2000 /2005, VERITAS Backup, Tivoli Storage Manager, Autosys, Precise, Windows 2003 Server, Win 2000 Prof/Advanced Server, SQL LiteSpeed, Windows Cluster.

Confidential

SQL Server DBA

Responsibilities:

• Provide support to 20+ SQL Server 7 and SQL Server 2000 instances running on Windows 2000
• Implemented Cincom CRM software on SQL server 7.0 database.
• Installed and Configured OLTP environment for 250 concurrent users
• Creation of Databases and granting required access
• Perform database maintenance - Backups/restores
• Experience in working with Reporting Services to manage reports for organizations.
• Maintained ER diagrams for each database and data flow diagrams for each applications.
• Developed Stored Procedures, Triggers and Views for Database Maintenance.
• Tuned database performance thru SQL Profiler. Tuned memory and server related issues.
• Optimizing SQL Query and procedures by creating appropriate indexes.
• Setting up of Transactional Replication to remote servers.
• Installed SQL Server on Windows 2000 Server
• Troubleshoot SQL Server issues related to Datacenter migration.
• Monitoring common performance problem and solving them.
• Responsible for General Database Administration and Performance tuning.
• Designed DTS packages to transfer data from different sources such as from Excel, Text file, Access
• Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
• Design and implemented Disaster recovery plan.
• Setting up replication with multiple remote servers to different sites through ODBC using TCP\IP connections across WAN.

Environment: MS SQL Server 6.5 / 7.0, WIN 2000 /Advanced Server, SQL LiteSpeed, Windows Cluster, TCP/IP

Confidential

SQL Server DBA / Sr. Developer

Responsibilities:

• Analyzed the existing system and designed application to meet the requirement
• Designed and created databases after Normalization
• Developed Stored Procedures, views and triggers
• Applying new MS SQL Server upgrades, releases and security patches to keep the database at current patch level.
• Setting up of Transactional Replication to remote servers.
• Developed front end application in VB 5.0
• Involved in installation and configuration of SQL server 2000
• Designed output forms using Crystal reports.

Environment: MS SQL Server 7.0, MS Access, VB 5.0, Crystal Reports.

Confidential

Software Engineer

Responsibilities:

• Design and creation of databases
• Creating stored procedures, triggers, and views
• Optimizing stored procedures and defining guidelines for developers
• Creating and Maintaining DTS Packages and SQL Agent Jobs
• Scheduling of Backup and other Maintenance jobs.
• Managed Users and Permissions.

Environment: MS SQL SERVER 7.0