Installation, configuration, administration, upgrades, patching, implementing backup/recovery, continuous monitoring, tuning, capacity planning, and site failover for 250 SQL Servers and 30 MySQL Servers. Implemented High Availability and Disaster Recovery scenarios with: Always On 2 node synchronous commit with automatic failover setup used for vCenter databases.Chained Transactional Replication 2-4 servers setup used for CRM.Database Mirroring – 2 Node High Safety Mode Bi-Directional mirroring between 2 servers with different witnesses setup used for Blackberry Enterprise Server between US/UK - UK/US.Failover Clustering – Windows 2008 r2 4 Active 1 Passive Star Cluster in which each node can handle failover of 4 instances setup used for various critical application databases.Designed seamless database deployment architecture between staging and production databases with active\​passive databases controlled by SSIS and Controller database used for switching databases. Developed SSIS packages for monthly tax break-down by city, county and zip, redesigned eBook sales tax consolidation processes.Administered 26 MySQL 5.1 Servers and 4 MySQL 5.1 Clusters to ensure integrity, security, optimization and availability of databases.Designed, build and maintained WordPress environments.Designed and build Master/Slave replication.Designed a centralized MySQL backup architecture with compression and archiving.Setup backup and storage alerts.

Administration of 12 MS SQL, 12 MySQL and 6 Oracle database servers spanning 120 databases.Microsoft SQL Server: CRM, Equitrac/RightFax, HFM Intranet, AgileQuest, Blackberry, Contests and in-house applications. MySQL: www.caranddriver.com, www.roadandtrack.com, www.cycleworld.com, www.womansday.com, www.elle.com, www.ellegirl.com, www.elledecor.com, Oracle: PeopleSoft Financials, ADP Payroll, Admarc.Responsibilities• Upgraded 6 sql servers from 2000 to 2005 and 2 from 2000 to 2008.• Installed and configured Linux HA Heartbeat with MySQL in active/passive mode attached to SAN.• Setup master slave replication for all mysql production databases.• Upgraded PeopleSoft 8.43 database from Oracle 9i running on Windows 2003 to PeopleSoft 8.49 Oracle 10g and later to Oracle 11g running on OEL5 (Oracle Enterprise Linux).• Designed and implemented Integrated Marketing Database (IMDB) consisting of 5 SSIS packages and 3 databases. ETL with data hygiene and migration using DataLever from 2 data sources (Kable and Equifax).• Created backup plans for MS SQL/MySQL/Oracle Servers including full, differential, and archive/transaction logs. • Setup database mirroring and log shipping for Digital Asset Management Project.• Virtualized 2 SQL 2000, 2 SQL 2005 and 1 Oracle 9i servers.• Managed switches and firewalls. Setup vlans and assigned public ip’s for servers in DMZ zones.• Configured LUN’s, setup ISCSI and NAS nfs and cif mounts. Managed SAN and NAS environments.• Designed and managed VMware 3.5 and vSphere 4.1 virtualized environments. • Monitored virtual infrastructure using vCenter.Tuning: • Redesigned stored procedures and optimized all indexes used in the where clauses using SQL profiler, Index tuning wizard and slow query log for all above mentioned sites.• Relocated transaction logs, indexes, data files and backups to separate RAID drives placing data and indexes on RAID 10 and logs and backups on RAID 1.• Optimized MySQL Server for vbulletin forums.

Maintained Spa Finder database and development architecture for www.spafinder.com.Created custom reports and automated distribution via email on daily weekly and monthly basis.Created weekly flat files for fulfillment house using BCP and SFTP.Created disaster recovery plan with transaction logs, differential and full backups.Redesigned indexes, stored procedures and triggers eliminating temp tables.Designed new forms, queries and reports for Gift Certificate Redemption System (Access 2003).

Designed developed and implemented various production databasesApplication Development Process, Defining and Enforcing Database Standards. Creating Stored Procedures and User Defined Functions, Implemented Triggers.Used Data Transformation Service (DTS) for import and export.Utilized Erwin 3.5 database designing tool for schema generation and maintenance, logical and physical database designs and enterprise modeling.Created triggers for auditing record creation, deletions and updates.www.MyMedic.com - National Directory of medical practitioners. - Schema designs included office locations, hours, accepted insurance plans, physician credentials, and personal achievements.- Design and development of automated data acquisition, clean-up/translation and database import using FTP, DTS packages.www.AmericanLegalNetwork.com - A network of lawyers nationwide for individual cases.- Designed Site Content Tables & Free Initial Consultation process tables