SUMMARY

• Over 5+ years of experience in SQL server database administration and development
• Migrating SQL Server 2000 databases to SQL Server 2005.
• Maintaining databases in 24X7 production environment.
• SQL SERVER 2005 cluster.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Hands on experience in trouble shooting database issues.
• Experience in implementing different types of Replication models like Snapshot and transactional.
• Specific hands on experience include Administering large and complex Databases, Normalization, Replication, Log shipping, Full-text indexing.
• Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Worked closely with management, applications development staff, and users on database solutions to business problems.
• Experience working with production and 24 x 7 on call environments.
• Worked with preparing the documentation for GAP analysis, Technical Specification documents, Functional Speciation documents, mapping documents etc.., for the various migration and up gradation projects.

PROFESSIONAL EXPERIENCE:
Confidential, Indianapolis, Indiana May 10 - Present SQL Server DBA

Confidential was founded by Confidential in 1876, and are now the 10th largest pharmaceutical company in the world. We have steadfastly remained independent, but not isolated. Across the globe, Confidential has developed productive alliances and partnerships that advance our capacity to develop innovative medicines at lower costs. Confidential is consistently ranked as one of the best companies in the world to work for, and generations of Confidential employees have sustained a culture that values excellence, integrity, and respect for people.

• Managed 600+ SQL Servers, from 20 gb servers to a 2 terabyte.
• Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of sales force automation and product routing.
• Installing SQL Server 2005, 2005+sp1, SQL 2008, SQL 2008 R2 and Client tools.
• Implemented Quest LiteSpeed backups to network drives to replace outdated tape-based backups.
• Backup windows shortened from as long as 16 hours down to under 2 hours, enabling company to keep more backups online. Proactively monitor the production SQL infrastructure environments to ensure continued availability of the database services.

• Deploy maintenance and support actions for the production Windows servers running SQL services.
• Develop processes to increase efficiency and automate regular maintenance of support actions.
• Provide on-call support.
• Assist Infrastructure team with testing and implementation of new Service
• Packs and hotfixes releases. Upgraded SQL Server boxes 6.5, 7.0, 8.0 or 2000, 90 or 2005, Installed the required SQL Server Service Packs
• Move system database files including the master database files.
• Configured the Tempdb data files to match the current amount of logical CPUs.
• Deployed Replication between SQL Server 2005 servers. Also Deployed replication between SQL Server 2005 and SQL Server 2000.
• Implemented and maintain a replication environment. Use SQL Server Replication utility.
• Migrated DTS and SSIS packages and SQL Server jobs to new servers.
• Created script to extract the logins (usernames), UserIds and their corresponding encrypted password. When, required, reestablished the logins and their corresponding credentials in Development and Test environments.
• Worked in a cluster server environment.
• Monitored availability and performance of production databases and servers.
• Created SQL Server jobs to automated and schedules transfers of large amount of data(i.e. 5 Terabytes).
• Provided server administration support: backup/restore, security access, etc.
• Designed disk drives to separate data, log, backup files, OS files and misc files. Labeled disk drives with appropriate identifier names.

Confidential, TX Dec 09 – April 10 SQL Server DBA 
Confidential, one of the biggest telecommunication companies in the Unites States, provides not only wireless and wire communication but also broadband internet access service as well, serving 53 million customers nationwide; The project that I worked is a Migration project and total production support.
Responsibilities:

• Worked on SQL Server solutions including log shipping, Replication, SQL Server Clustering and Migration.
• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Working in 24X7 production environment.
• Participated in introducing MS SQL Clustering for critical application.
• Worked on Database refresh, upgrading and migration.
• Strong hands on encryption and security of databases.
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Handling data in terabytes.
• Resolving IR (trouble ticket) in 24X7 production support.
• Working directly with architect and designers to create DR and implementation of physical data model.
• Working directly with application team and other team as per requirement.
• Worked on Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases.
• Experience working on Veritas backup.
• Proficient in implementing clustering, mirroring and log shipping on SQL Server 2005.
• Created and administered multiple development, training and production databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assuranceincluding database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Troubleshoot databases and custom application issues.
• Eased administrative work through automatic script performing daily/weekly backups.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Working with BMC patrol and other tools.
• Managed the granting of access to operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support
• Developed and maintained Database administration with SQL Server.
• Maintained databases, configured permissions, and conducted backup and recovery.
• Performed daily administration, monitoring, and documentation of SQL Servers.
• Responsible for tuning data, indexes, and queries.
• Provided assistance to development teams on tuning data, indexes and queries.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Configured securities and accesses to production databases and database servers.
• Monitored all databases status including CPU, memory, Management, block, and dead lock.
• Provided technical support to internal developers and external clients.

Environment: Visual Studio 2005,Visual Studio 2008 SQL Server Management Studio, T-SQL Stored Procedures, VMWare 4.x, SQL Server reporting services (SSRS), .NET, SQL Server Integration Services (SSIS), Team Foundation Server, Office, Excel.

Confidential , ILLINOIS May 08 - Nov 08 SQL Server DBA 
This is a small Consulting Company introduced in the world of IT tackling small projects. I worked as a SQL Developer/DBA more of DBA work. This was a outsourced project by Verizon and use to work offshore for the Client.

• Worked on SQL Server solutions including log shipping, Replication, SQL Server Clustering and Migration.
• Conducted Performance tuning/MS SQL server development - SQL Profiler, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Working in 24X7 production environment.
• Participated in introducing MS SQL Clustering for critical application.
• Worked on Database refresh, upgrading and migration.
• Strong hands on encryption and security of databases.
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Handling data in terabytes.
• Resolving IR (trouble ticket) in 24X7 production support.
• Working directly with architect and designers to create DR and implementation of physical data model.
• Working directly with application team and other team as per requirement.
• Worked on Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases.
• Experience working on Veritas backup.
• Proficient in implementing clustering, mirroring and log shipping on SQL Server 2005.
• Created and administered multiple development, training and production databases.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assuranceincluding database consistency check.
• Responsible for creating standards and operating procedures to maintain all databases.
• Worked with development teams in the design of physical databases and in modification.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Troubleshoot databases and custom application issues.
• Eased administrative work through automatic script performing daily/weekly backups.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of the operational and developmental application system databases.
• Working with BMC patrol and other tools.
• Managed the granting of access to operational and developmental application system databases.
• Managed MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
• Daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support
• Developed and maintained Database administration with SQL Server.
• Maintained databases, configured permissions, and conducted backup and recovery.
• Performed daily administration, monitoring, and documentation of SQL Servers.
• Responsible for tuning data, indexes, and queries.
• Provided assistance to development teams on tuning data, indexes and queries.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Configured securities and accesses to production databases and database servers.
• Monitored all databases status including CPU, memory, Management, block, and dead lock.
• Provided technical support to internal developers and external clients.

Confidential, Chandigarh ,INDIA Jan06 – Dec 07
Database Developer/DBA
Responsibilities:

• Administered various applications like Maintenance Management and Financial Account System.
• Maintained the client\'s Sales and Customer Databases and tuning of the database instances.
• Administered all database objects, including tables, clusters, indexes, views, Sequences packages, and procedures.
• Troubleshoot problems concerned with the Databases, Applications, and Development tools.
• Created new databases for users as required. Checking the alert logs daily for oracle errors.
• Tuning of I/O to reduce disk contention by distributing I/O.
• Data Modeling, normalization, de-normalization, physical database design, and relational models.
• Enforced security for all of the SQL Databases. Data loading using SQL*Loader. Manage sharing of resources amongst applications.
• Creating and maintaining Triggers, Packages, Functions, and Procedures.
• Creating and maintaining roles and profiles for security and limited access of data.
• Design and implementation of Backup & Recovery strategies.
• Creation of logins and user ids and setting up privileges and procedures for protection of data.
• Designed screens and reports layout.
• Used PL/SQL to write the Stored Procedures /triggers and data validation routines.

Environment:Windows NT 4.0, IIS 3.0, ASP, Oracle 8, Crystal Reports 5.0, HTML, DHTML.