PROFESSIONAL SUMMARY

• Extensive experience in installation, configuration and administration of SQL Server 7/2000/2005/2008.
• More than 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 200 SQL 2000/2005 servers and 500+ databases in clustering environment (A/A, A/P) and databases 500+ Gig in size
• Import and export data (Dev to QA, QA to Prod)
• Technical Lead in charge of migrating over 180 databases from SQL Server 7.0 to SQL Server 2000 and SQL 2000 to SQL 2005
• Implemented a recovery plan to a point in time failure
• Responsible for data security and Integrity with HIPAA requirements
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, 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 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

WORK EXPERIENCE

Confidential Auburn Hills, MI
Sr. SQL Server DBA 04/2010 – 12/2010

• Responsible for provide 24 X 7 critical production support to all 100 Production, development and clustered servers.
• Maintained 85 mission critical applications.
• Supported over 100 SQL 2000/2005 databases in 5 node clustering environment (A/P A/A) including database mirroring on critical databases and databases 400+ Gig in size
• Successfully Upgraded SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008
• Designed, implemented, configured SQL 2008 DEV/QA environment on 2 node A/P cluster environment.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Created snapshot of mirror database for reporting
• Configured and maintain transactional, merge replications.
• Designed and deployed SSIS packages in production environment to implement business logics.
• Create, deploy, configure and monitor complex ETL/SSIS packages
• Installed SQL Server 2005 in clustered configuration. Planned, configured, tested and implemented failover cluster on Windows 2003.
• Configured SSIS services, Database Mail, NETIQ Monitoring and Alerts on cluster.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2000 to MSSQL 2005.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2000 & 2005.
• Tested and applied latest service packs and cumulative Hotfix for SQL 2000/2005/2008.
• Installed and configured SQL 2005 Report and Analysis Services.
• Created DDL triggers for auditing any DDL change in SQL 2005
• 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.
• Created maintenance plan for database consistency and optimization.
• Document server and database policies and procedures.
• Involved in Change Management, Problem management activities using Service Now tool before implementing database changes in production and development activities.
• Created the backup and restore strategy for production, development and test environments.
• Involved in Disaster recovery and created the documentation.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Created custom Performance Analysis reports in SQL 2005 for future hardware and software load/analysis.
• Determined hardware and software requirements for SQL Server version 2000 and 2005. Determined the SQL 2005 installation options. Tested the Installation of SQL 2005 Server.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Manage and resolve trouble tickets (HP service manager SM7) for database-related issues submitted by customers.

Environment: Windows 2003/2008, SQL 2000/2005/2008, T-SQL, Replication, SSIS, SSRS, Database mirroring, MS clustering, LiteSpeed, MOM 2005/2007, NETIQ, HP SM7

Confidential Melville,NY 10/2007– 12/2009
Sr. SQL Server DBA

• Responsible for providing 24 X 7 critical production support to 50+ Production, development and clustered servers.
• Implemented and maintained high availability systems (clustering, database mirroring, log shipping)
• Successfully migrated 200 SQL 2000 databases to SQL 2005
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2000 to MSSQL 2005.
• Create, deploy, configure and monitor complex ETL/SSIS packages Wrote stored proc 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.
• SQL Server 2005 clustering on Windows 2003/2008 cluster environment for high availability.
• Create and manage database maintenance plans and design and implement backup and disaster recovery plans.
• 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
• Manage and resolve trouble tickets (WebTrack) for database-related issues submitted by customers.

Environment: Windows 2003/2008, SQL server 7/2000/2005/2008, T-SQL, Replication, Log shipping, failover clustering, LiteSpeed

Confidential Madison, WI
08/2005 – 10/2007
Sr. SQL Server DBA

• Researched, analyzed and designed DHFS SQL Server 2000 environment.
• DBA for SQL Server serving over 180 databases and one instance of Sybase servers. Responsibilities include daily maintenance review, SQL optimization, disaster recovery planning and testing and custom software database installation support. Working as a team member with other DBA\'s to ensure 24 hour x 7 day a week support of all corporate databases.
• Involved in installing, configuration and administration of failover clustering
• Provide support to application developers in designing and implementing physical database structures.
• Wrote stored proc to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization
• Researched, designed and tested a migration plan from SQL Server 7.0 to SQL Server 2000.
• Technical Lead in charge of migrating over 180 databases from SQL Server 7.0 to SQL Server 2000 using DTS and Embarcadero DBArtisan 8.0, 8.1
• Designed DR database backup and restore plan.
• Researched and implemented a recovery plan to a point in time failure.
• SQL Server performance statistics collection, Server monitoring and performance tuning.
• User account management and connection troubleshooting.
• Research, test, modify and install vendor applications such as Sams2000, TX Management and PPSEE, CBORD, TimeMatters, TonxiNet and WinSchool, BlackBerry and Great Plains 7.5, 9.0
• Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, Log shipping, SQL Mail Manage small, medium and large SQL Server 2000 projects.
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Implemented data models, database designs, data access
• Import and export data (Dev to QA, QA to Prod)
• 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).
• Researched and migrated CBORD FMS with Sybase database to SQL 2000
• Experience in installation, configuration and administration of SQL Server 2005 Technical Lead in charge of migrating SQL Server 2000 to SQL Server 2005
• Upgraded Great Plains 6.0 to 7.5 from SQL Server 7.0 to 2000 and 7.5 to GP 9.0
• Formulated and monitored policies, procedures, and standards relating to database management.
• Responsible for data security and Integrity with HIPAA requirements.
• Provided project leadership within a functional database area of specialization.
• Manage and resolve trouble tickets (Peregrine service center) for database-related issues submitted by customers.

Environment: Windows 2003, SQL server 7/2000/2005, Sybase, T-SQL, Replication, Log shipping, failover clustering, DBArtisan, Idera (SQLSafe, SQL compliance manager)

Confidential Dearborn, MI
SQL Server DBA 12/2001 – 08/2005

• Provided 24 X 7 critical Support over 50 SQL 2000 servers and over 200 databases in clustering environment, associated with high volume websites with database size 500+ Gig in size.
• Implement and maintain database security, replication, SQL Clustering, DTS, Log shipping, SQL Mail.
• Extensively involved with Backups and Recovery, Log Shipping and Replication
• Import and export data
• Promote/migrate SQL-Server objects from development to QA and QA to production instances
• Provide support to application developers in designing and implementing physical database structures.
• Implemented data models, database designs, data access
• Implemented security, generate and review report periodically and enforce security mechanism
• Maintain database integrity of all vendor and in house databases.
• Resolve and troubleshoot database issues, oversee and perform upgrades, conversions and deployments.
• Performance tuning - Monitor efficient use of memory and CPU resources.
• Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization
• Identifying performance bottlenecks (OS, Network, Database), tuning of Both SQL statements and tuning of the RDBMS software, and recommend optimal performance recommendations.
• Hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company’s databases and systems
• Participates in emergency recovery of databases as well as manages physical structures, space utilization and participates disaster recovery testing.
• Documented database processing procedures, operations run books and system documentation and training of data processing and user personnel on system usage.
• Manage and resolve trouble tickets (Remedy) for database-related issues submitted by customers.

Environment: Windows 2000, SQL server 7/2000, IIS 4.0/5.0, T-SQL, Replication, Log, Shipping, MS failover clustering, DBArtisan, Quest Lite Speed, SQL Watch, (Site Scope, TSM)

EDUCATION
Bachelor of Computer Science

CERTIFICATIONS/TRAINING
MCSE – Microsoft Certified System Engineer – Windows 2000
MCDBA – Microsoft Certified Database Administrator – SQL Server 2000
Linux (SuSe)/Oracle 9i & WAS 5 Administration and Application Integration training

TECHINCAL SKILLS

Database: Microsoft Access, SQL Server 7, 2000, 2005, SQL 2008
Web Servers: IIS 4.0/5.0, 6.0, WebSphere 5.0
Network Services: TCP/IP, DNS, HTTP, SMTP, DHCP, Load Balancers
O.S.: Windows NT/Windows 2000/2003/2008
Applications: Active Directory, MSCS Clustring
Tools: DBArtisan 8.x, Quest (Lite Speed, SQL Watch), Idera (SQLSafe, SQL compliance manager)
Languages: Transact-SQL, ASP, VB/JavaScript