SUMMARY

• Extensive experience in installation, configuration and administration of SQL Server 2005/2008/2008 R2/2012.
• Around 8 years of experience as Sr. SQL Database Administrator on Windows 2000/2003/2008.
• Extensive experience in installing, configuration and administration of MS clustering.
• Experienced in T - SQL Programming and performance tuning, optimization
• Extensively involved in 24/7 Production support of the databases and round-the-clock database operations
• SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases
• Supported over 400 SQL version servers and 900+ databases in clustering environment (A/A, A/P), Mirroring, Log Shipping and Always On.
• Supported over databases from 100 MB to 1 TB.
• Import and export data (Prod to Dev. to QA, QA to Prod)
• Technical Lead in charge of migrating over 180 databases from SQL Server 2005 to SQL Server 2008/2008R2 and SQL 2008 to SQL 2012.
• Recovered many databases to point in time or max possible data in many cases during database corrupted or accidentally dropped objects due to human error.
• Responsible for data security and Integrity complying with company standards.
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, SSRS, Log shipping, Database Mirroring, SQL Mail, database mail
• Responsible for establishing best practices, standards
• Responsible for establishing and enforcing security mechanism
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments
• Experience in writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables
• A hands-on SQL Server Database Administrator (DBA) and Web Administrator with a proven track record of team leadership and technical skills
• Provided 24X7 On-call support when needed
• Keeping up to date with latest technology and features
• Expert in using DMV’s, Trace Flags and DBCC commands
• Performance increase through tuning queries and training developers with tips on coding.
• Saved few hundreds of thousands of dollars to my clients where I worked by designing architecture of applications as needed to meet the SLA’s
• Consolidating servers where involved cost savings vs performance.

TECHNICAL SKILLS

Database: SQL Server 2000/ 2005/2008/2008 R2/2012/2014, Oracle 11g/11g R2, MYSQL

Web Servers: IIS 4.0/5.0, 6.0, m Web Sphere 5.0, Apache

Network Services: TCP/IP, DNS, HTTP, SMTP, DHCP, Load Balancers, Named Pipes

OS: Windows NT/Windows 2000/ 2003/2008/2008 R2/2012, Unix, Linux

Applications: Active Directory, Citrix, share point etc

Tools: Red-Gate (SQL Compare, SQL Monitor, SQL Backup, SQL Doc), Quest(Now Dell)-Lite Speed, Idera (SQL Safe, SQL compliance manager), IBM-Tivoli

Languages: Transact-SQL, ASP, VB/JavaScript, HTML, PowerShell 1.0,2.0, ISE.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. SQL Server DBA

Responsibilities:

• Architect, design and implement new solutions enterprise level
• Design and set standards for the database maintenance, procedures and deployments
• Migrated multiple applications from 2008 R2 to SQL 2012 (SSIS, SSRS and SSAS too)
• SLA’s were cut down from hours to almost instant with introduction of Always-On
• Implemented SQL Monitoring solution Ignite for mission critical apps
• Implemented and deployed highly significant maintenance solution
• Saved Many dollars with performance tuning apps instead throwing hardware
• Created and deployed many custom reports for managing of multiple servers
• Implemented multiple HADR solutions for mission critical apps and also making use of the stand by servers for reporting
• Capacity planning monitoring with database growth over the period of the time.
• Involved with new SSAS enterprise data warehouse build and created multiple SSIS packages for incremental loading.
• Migrated and upgraded servers from different old version to new 2012 and 2014 servers.
• Implemented many automated task which been historically done manually using PowerShell, T-sql or Command line utilities.
• Had dealt with Log Shipping, Replication, Mirroring and Always-ON availability groups.
• Built multiple clusters in windows server 2012.
• Involved with whole new storage migration from NetApp to Nimble storage hybrid.
• Took many performance baselines and done analysis using perfmon, psdiag, sqldiag.
• On-call support, weekend support where and when needed.
• Done windows patching for all sql servers across the enterprise.
• Keep learning and stay up to date with SQL server latest and greatest technology.
• Stay tuned with Service packs and make sure systems are secured and bug free.

Environment: Windows 2003/2008/2008 R2/2012, SQL 2000/ 2005/2008/2008 R2/2012/2014, T-SQL, Replication, SSIS, SSRS, Database mirroring, MS clustering, Lite Speed, Solar winds, Red Gate, Citrix, MYSQL.

Confidential, Concord, CA

Sr. SQL Server DBA Consultant

Responsibilities:

• Responsible for providing 24 X 7 critical production supports to 500 + Production, development and clustered servers.
• Implemented and maintained high availability systems (clustering, database mirroring, log shipping)
• Great team of DBA’ supporting all SQL server database spread across different datacenters across the world (California, Texas, Atlanta, London and Singapore)
• Create, deploy, configure and monitor complex ETL/SSIS packages Wrote stored procedures to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization
• Automated daily backup/restore processes, implemented batch jobs to automate DBA maintenance tasks.
• Defined many policies and automated process for less administration since it is he stack of servers.
• Create and manage database maintenance plans and design and implement backup and disaster recovery plans.
• Conducted DR tests periodically for group of servers.
• Define and enforce database standards, policies, security and documentation.
• Prepare current database structure and configuration for high-performance through analysis and optimization.
• Implementation of Database mirroring and transactional replication.
• Diagnose problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues.
• Monitor database systems performance, capacity and availability.
• Work on data mapping and conversion; manage disk space, change control and bug fixes.
• Developed and implemented Disaster Recovery (DR) on production SQL Server 2005/2008/2008 R2/2012
• Manage and resolve trouble tickets for database-related issues submitted by customers within the organization.
• All most all Red Gate tools I have used including SQL Monitor, SQL Compare etc.
• Responding to SCOM alerts and create documentation for common issues for Jr DBA’s
• Assisted many deployments and code releases for mission critical applications

Environment: Windows 2003/2008/2008 R2, SQL 2000/ 2005/2008/2008 R2/2012, T-SQL, Replication, SSIS, SSRS, SSAS Database mirroring, MS clustering, Lite Speed, MOM 2005/2007, SAN and Red Gate.

Confidential

Sr. SQL Server DBA consultant

Responsibilities:

• Responsible for provide 24 X 7 critical production support to all 400 Production, development and DR servers.
• Commitment to SLA based on ticketing system where responding time with 15 minutes to production and 45 minutes to other environments.
• Maintained 200 mission critical applications
• Successfully Upgraded SQL 2005 to SQL 2008/2008R2 and SQL 2008 to SQL 2012
• Designed, implemented, configured SQL 2005/2008/2008 R2/2012 DEV/QA environment
• Tested and applied latest service packs and hotfix for SQL 2000/ 2005/2008/2008 R2/2012
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy
• Install and configuring Report Servers and designing SSIS packages for refresh the report databases over nightly
• Extensively configured log shipping and addressing issues with it during day and on-call.
• Create, deploy, configure and monitor complex ETL/SSIS packages
• Experience with performing DR tests periodically for mission critical application.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2000, 2005, 2008, 2008R2 and 2012 versions
• Installed and configured SQL 2005/2008/2008 R2 Report and Analysis Services.
• Created DDL triggers for auditing any DDL change in SQL 2005/2008/2008 R2.
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data
• Installed, configured and maintained Log shipping to create Standby Server.
• Developed and implemented customized maintenance plans to meet the needs and keep up to date with the glitches and fixes for performances issues.
• Document custom database installation procedures, security standards based on environment and SLA and keep update the inventory of servers periodically.
• Involved in Change Management, Problem management activities using BMC Remedy tool before implementing database changes in production.
• Created the custom backup and restore strategy for production, development and test environments.
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards
• Determined hardware and software requirements for SQL Server version 2005 and 2008/2008R2.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• On-call support during off-hours on rotation basis.

Environment: Windows 2003/2008/2008 R2, SQL 2000/ 2005/2008/2008 R2, T-SQL, Replication, SSIS, SSRS, SSAS Database mirroring, MS clustering, Lite Speed, MOM 2005/2007, SAN and Red Gate.

Confidential, Pleasanton, CA

SQL Server DBA\Developer

Responsibilities:

• Installed SQL Server 2000/2005 and created Development Database for testing, upgrades and development
• Created System Schema Diagram and Tables.
• Created logical Entity relationship diagrams and implemented logical model physically.
• Created Database objects like store procedures, triggers, views etc
• Set up Database Maintenance Plan using SQL Server Enterprise to update the statistics.
• Performance tune stored procedures, to make the report processing faster.
• Used log shipping for synchronization of database.
• 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.
• Performed daily backups and created named backup devices to back up the servers regularly.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Setup the agents for replication and defined disaster recovery plan.

Environment: Windows 2003, SQL 2000/2005, T-SQL, Replication, DTS, SSIS, SSAS, BIDS, Database mirroring, MS clustering, SAN and Red Gate.

Confidential, San Francisco, CA

SQL Server DBA\Developer

Responsibilities:

• Involved in installing, configuration and administration of log shipping, Replication and Mirroring based on business requirement
• Provide support to application developers in designing and implementing physical database structures.
• Wrote stored procedures to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization
• Researched, designed and tested a migration plan from SQL Server 2005 to SQL Server 2008/2008R2.
• Lead in charge of migrating over 80 databases from SQL Server 2005 to SQL Server 2008/2008R2 SSMA and native scripts
• Designed DR plan, database backup and restore plan to point in time
• SQL Server performance statistics collection, Server monitoring and performance tuning using perfmon, SQL Server profiler and Index tuning advisor
• User account management and connection troubleshooting issues with application team.
• Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Trained members of the Network Access team to handle SQL Server account management.
• Audit and generate monthly management reports using third party tool
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user logins, and passwords (security)
• Experience in installation, configuration and administration of SQL Server 2005/2008/2008 R2 Technical Lead in charge of migrating SQL Server 2005 to SQL Server 2008/2008R2
• Formulated and monitored policies, procedures, and standards relating to database management
• Provided project leadership within a functional database area of specialization
• Manage and resolve trouble tickets for database-related issues submitted by customers

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 (R2), Microsoft SQL Server 2000 and 2005, Windows 2003/2008 Server, Share point, IIS 6.0, SCOM, OEM and VERITAS Net Backup.

Confidential

Jr. Database Administrator

Responsibilities:

• Installed SQL Server 2000/2005 and created Development Database for testing, upgrades and development
• Created System Schema Diagram and Tables.
• Created logical Entity relationship diagrams and implemented logical model physically.
• Created Database objects like store procedures, triggers, views etc.
• Set up Database Maintenance Plan using SQL Server Enterprise to update the statistics.
• Performance tune stored procedures, to make the report processing faster.
• Used log shipping for synchronization of database.
• 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.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Setup the agents for replication and defined disaster recovery plan.

Environment: Windows 2003, SQL 2000/2005, T-SQL, Replication, DTS, SSIS, SSAS, BIDS, Database mirroring, MS clustering, SAN and Red Gate.