SUMMARY

• Has 13 years of IT experience as a senior lead Database Administrator consultant (MySQL - MariaDB-Percona server, PostgreSQL, MS SQL Server, Apache Cassandra-NoSQL), data architect, DBA manager in variety of domains ranging from Insurance industry, Finance industry, Manufacturing industry, Law firms, Food industry, Retail sector, Media/Entertainment industry and University colleges.
• He has worked extensively on supporting the SaaS, PaaS implementations (Cloud), clustered environments of MySQL, PostgreSQL, Microsoft SQL Server, Cassandra infrastructures in enterprise environments and other high availability solutions like MySQL Fabric, SQL Server mirroring, replication, log shipping.
• As a production support DBA and application DBA has mastered the skill of performance tuning, has been on the on-call support and resolved the issues as per the SLA’s, maintained the database systems as per the SOX compliance, ITIL certification standards and has the experience of working as a lead DBA for a team of 3 members.
• His main interest is MySQL Servers, PostgreSQL-EnterpriseDB, MS SQL Servers, SAP HANA, Cassandra, MongoDB, CouchDB, DocumentDB, Redis, BigTable database servers, Oracle database servers, Elasticsearch servers, Linux/Unix servers, Openstack, Amazon web services(AWS-RDS), Azure, Windows servers, SharePoint servers, SQL Server analysis services (SSAS), SQL Server reporting services (SSRS), SQL Server integration services (SSIS).
• He has the technical expertise needed to resolve the mission critical database issues and soft skills needed to be a part of the corporate team to promote the overall growth of the organization. Have completed six certifications as described below:
• MySQL/Percona (5.0 to 5.7), MariaDB (5.1 to 10.1.18) Servers administration, Replication, MySQL Fabric, SQLYog, MySQL Workbench, INNODB Galera Clustering, Percona Xtrabackup- XtraDB-toolkit, MySQL Enterprise Monitor/Backup(MEM-MEB), phpMyAdmin, MySQL plugins, Guerrilla capacity planning.
• PostgreSQL administration 9.0.x to 9.6.x, Slony-I replication, psql, phpPgAdmin, Apache Cassandra administration 2.1/2.2, LAMP stack, Cloud- Openstack, Microsoft SQL Azure, PaaS (Platform as a Service)
• MS SQL Server administration 2000 to 2014/2016, fail over clustering, AlwaysOn, Transactional replication
• BI Stack: SQL SERVER Integration Services, Analysis Services, Reporting Services, BI studio, Data tools
• T- SQL (Transact SQL), UNIX shell scripting, PowerShell 1.0/2.0/3.0, MS Access, MS Excel (Pivot tables)
• SQL Server auditing and database level auditing (CDC and DDL triggers), Transparent data encryption (TDE)
• Microsoft dynamics great plains(GP), Montera’s Microsoft Dynamics CRM SaaS (Software as a Service) Cloud, Salesforce CRM (SFDC), Epic Clarity application, Oracle E-Business Suite(EBS), MS Visio
• Oracle/Sybase/TeraData/DB2, Windows Clusters, VMware, EnterpriseDB-PostgreSQL, Github
• SharePoint 2007/2010/2013 , Internet information services (IIS servers), Microsoft Active Directory Services
• Windows Server 9x/NT/2000/XP/ 2003/2008/2008 R22012R2, RHEL/centOS Linux
• 13 Years of IT experience in MySQL, PostgreSQL, Microsoft SQL Server, Apache Cassandra working as DBA Manager, Database Administrator, architect, report writer and Developer in Insurance, Finance, Law firms, entertainment/media, manufacturing, ecommerce domains. Has operational knowledge of AWS-RDS.
• As a MySQL-MariaDB-Percona DBA installed, upgraded, configured high availability setup for MySQL servers from versions 5.0, 5.1 to 5.6/ 5.7 using MySQL INNODB & NDB cluster, multi-master replication manager.
• Extensive experience with phpMyAdmin, MySQL Workbench in monitoring, maintaining, troubleshooting production MySQL servers. Experience with MySQL monitoring tools Nagios XI, Icinga, Cacti, OpenTSDB.
• As a PostgreSQL DBA installed, upgraded PostgreSQL servers (versions 9.0 to 9.6). Built streaming cascaded & slony-I replications. Used Repmgr, phpPgAdmin, pgAdmin. Worked on Backups/restores using pg dump, psql & scaling with Pgpool, PgBouncer. Worked as LAMP admin.
• Worked exclusively on MySQL Backup technologies mysqldump, xtrabackup, lvmsnapshot, coldbackups and implemented partial backups loading from xtrabackup full backups in Percona 5.5 and 5.6 and MySQl 5.6
• As a SQL database administrator, performed End to End SQL Server administrative tasks ranging from installing, configuring servers to setup, administer SQL Server clusters, replication (Transactional and Merge), log shipping and Mirroring. Designed, Created databases in production and development environment.
• Experience with tools like Index Tuning Wizard, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Successfully migrated SQL Servers from 2005/2008/2008 R2 versions to 2012/2014 in enterprise data centers.
• Mastered the SQL Server database backup and restore strategies which include full, differential, transaction log (T log), striped, mirrored backups and complete restore, partial restore, piecemeal restore while working with the three recovery models namely full, simple, bulk-logged and various compatibility levels.
• Successfully installed SQL Server Always On high availability cluster, worked on Contained Databases, Availability groups(HADR) of SQL Server 2012. For SQL Server 2014/2016, installed stand-alone, Always On clusters for development, production environments and has firm understanding of new features like In-Memory OLTP, Updateable columnstore indexes, Delayed durability, Incremental statistics, Lock priority of online operations and Cloud features.
• As a Cassandra(NoSQL) DBA, worked on architecting, configuring, monitoring Cassandra clusters and databases on a multi-datacenter cluster.
• As a DBA manager, successfully recruited, built, aligned DBA team with 25 stake holders of 10 application development teams ensuring efficient cross-functional team cooperation for effective product delivery. Created processes, procedures to ensure easy on-boarding, knowledge transfer & production support.
• Expert in designing VLDB (Very large databases) using design methodologies like STAR Schema, Snowflake Schema. Installed SQL 2016 prod instances and worked on PolyBase engine, Polyglot data storages
• Experience with Business Intelligence Concepts like Data Reporting and Data Analysis
• Experience in migrating MS SQL Server in VMware (Vblock)environment
• Provided production support for the custom and COTS systems, Oracle E-Business Suite(EBS), change management tools which were a SaaS implementation.
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Strong experience in T-SQL, power shell Script-writing, performing backups/recovery, database monitoring, and performance tuning using SQL Profiler, SQL DBCC commands and Dynamic Management Views (DMVs), and Windows Performance Monitor.
• Installed, configured MS SQL fail-over clusters (Active/Passive & Active/Active) up to 4 Nodes for SQL Server 2012 / 2008 R2 servers in the production and development environment.
• Experienced Microsoft SQL Server BI developer. Strong Experience in package design and maintenance using SQL Server Integration Services (SSIS) 2005 and 2008. Recent work includes Data transforms, database maintenance tasks, custom field mapping etc.
• Worked on SQL Server BI Studio for SSRS, performed data validation, collected data, analyzed it, and implemented effective CRM plans. Experience in SSRS interfacing with SharePoint.
• Experienced SQL Data Warehouse Designer with SQL Server Analysis Service (SSAS) 2005 and 2008. Proficient in designing and administering SQL data warehouse solutions and utilizing Analysis Services tools such as Perspectives, Calculations, Actions, and partitioning.
• Mastered the performance tuning of the databases for the VMWare VCenter application.
• Worked exclusively on auditing of SQL Server at server level and database level (CDC(change data capture) for DML and DDL, DDL triggers)
• Experience in Transparent Data Encryption(TDE) to encrypt an entire database for Security
• Experience with SAP Application support while maintaining and administering SQL databases
• Worked with the backend Feed processing systems consisting of reports and legacy data uploads
• Hands on experience in understanding of BizTalk architecture and supporting the behavior of BizTalk Server Host Instances during SQL Server Failover
• Created SSIS packages for SQL Server 2005/2008/2008 R2/2012/2014 data migrations and loads.
• Expert in understanding needs, focusing on critical issues, translating them into technical actions and implementing successful resolutions. Advanced IIS 6, .NET server administration and troubleshooting.
• Extensively used Performance Monitor (PerfMon) for maintaining performance of database servers
• Experience in administration (installation, configuration, monitoring, upgrade) of large number of IIS based Web servers (versions 5, 6 & 7) with strong troubleshooting skill.
• Hands on experience in troubleshooting database issues and database backup and recovery procedures.
• Extensive experience in database migration and upgrade projects. Has migrated stored procedures, functions, triggers, database schema (DDL), BTEQ scripts from TeraData to SQL Server 2008/2008R2.
• Migrated Confidential DB2 v8.2 databases to SQL Server 2005/2008R2 for Visual Studio and .NET Developers
• Experienced in working on SOX environment for SQL Server, Microsoft Active Directory Services on windows servers. Experience with Visual Studio 2010 using Team Foundation Server.
• Written powershell scripts that are customized for a particular dataset - such as a morning health check, which outputs different base information on reporting every morning.
• Assisted the production support of DB2 v9.x on Linux/AIX in production and Staging environments
• Has troubleshoot operations console connections by installing Service pack for iSeries Access for Windows.
• Imported data from MySql to SQL Server 2012/2014 using SSIS and created linked servers for MySql in SQL Server 2008R 2/2012/2014.
• Has extensively used Microsoft SQL Server Migration Assistant (SSMA) v5.3 for migrating the oracle and MySQL databases to SQL Server 2012 and SQL Server 2008R2
• Experienced in supporting the epic application team by providing by providing the backups and restores for the epic clarity warehouse databases. Created multiple database platform reports with Crystal Reports.
• Excellent Report writer/designer with SQL Server Reporting Service (SSRS) 2005 and 2008.
• Assisted the development teams in installing MS SharePoint version 2007 and upgrading the SharePoint application from MS SharePoint version 2007 to 2010
• Experienced with Great Plains development, Microsoft Office Share Point Server 2007 and MS Office Suite such as MS Access, Excel, and Office.

TECHNICAL SKILLS

• SQL Server 2016 to 2000 with clustering (64/32 bit), AlwaysOn availability, Mirroring, Replication, log shipping, T-SQL, Linked Servers, MySQL 5.0 to 5.7, SQLYog, phpMyAdmin, LAMP, Apache Cassandra 2.1/2.2, PHP, Red hat Linux servers, centOS, puppet, Shell scripting, Putty, mRemoteNG, Winscp, Python, AIX, MySQL Workbench, INNODB, NDB, Percona, MariaDB, Percona XtraDB, Windows servers 2000/ 2003/2008/2008 R2/2012R2(x86/x64)
• MS Access 97/2000/ 2003/2007 , SSAS, SSRS, Domo, Epic Clarity, Kubernetes, SSIS, VSS, DTSRUN, SQL Azure(Cloud, SaaS, PaaS), Azure Management Portal, AWS-RDS, Openstack, BMC Remedy, Citrix Server XenApp 4.5, PowerShell 2.0/3.0, BCP, .Net, VMWare vSphere, Lumension EMSS agent, Visual Studio, C#, VB and ASPNet, IIS 5x/ 6x/7x, Confidential Tivoli Storage manager(TSM), Commvault galaxy, Autosys
• AS400, SolarWinds Orion SAM, OpenTSDB, Spotlight, Trend Micro Deep security agent, SSCM, SCOM, ER Studio, SharePoint MOSS 2007, MS Cluster Service(MSCS), XML, HTML, MCS, MOM 2005, SAN Storage, ServiceNow, Remedy Salesforce.com, JIRA, Github, TortoiseSVN, Team forge, AccessDatabaseEngine2010, DBAmp, Shavlik, SQL IDERA diagnostic manager, Visio, MS Excel, AJAX, BizTalk Server 2009, VERITAS Netback up iText.NET, ColdFusion MX 70, SQL Litespeed, WCF, MDX Queries, BO Data Integrator, Oracle 10g/9i, SAP, Sybase ASE, TeraData, Bteq, Team foundation server, CranSoft 4.5.1/5.3.x, EMC Timefinder, Enterprise manager, Query Analyzer, Embarcadero Rapid SQL-DBArtisan, Informatica, Unix, Microsoft dynamics great plains, Service Center, Service Broker, Citrix servers, TeraData, Cacti, Nagios XI, Icinga
• Rapid SQL, CMS .Net, iSeries Access, Feed processing systems, Lotus Notes, Confidential Sametime, Archiving, Backup & Recovery, Stored Procedures, DDL, SQL Litespeed, DBCC, Sarbanes-Oxley Act (SOX), ERWIN, DTS packages, BIDS, MS Project, ADO.NET, OLEDB, Oracle E-Business Suite(EBS), DB2 OS/390, Sybase ASE, MS Outlook, Analysis Services, Data Marts, Profiler, EKTRON CMS 400.NET, Document management system (DMS), Ektron Explorer, C, C++

PROFESSIONAL EXPERIENCE

Confidential, Emeryville, CA

Senior lead DBA MySQL

Responsibilities:

• Installed, administered, upgraded 80 MySQL-MariaDB servers from 5.0,5.1 to 5.6/5.7/10.1.18. Configured replication setups (Master - Slave, Master - Master) via load balancer VIP’s. Configured, maintained MySQL/MariaDB Galera clusters (INNODB), MySQL Fabric on production, development MySQL servers.
• Installed MEM (MySQL Enterprise Monitor), MEB (MySQL Enterprise Backup) on dev, production environments. Worked on the on-call rotation twice a month on every alternate week.
• Installed, upgraded 45 PostgreSQL servers (versions 9.0 to 9.6) from source packages on Linux machines. Configured, monitored asynchronous and synchronous cascading streaming replication, Slony-I.
• Worked with pg dump, psql for backups/restores of PostgreSQL servers. Enabled write ahead log(WAL) archiving for PITR (Point-in-time restores). Worked on Hot Standby, Pgpool, PgBouncer, Repmgr.
• Has extensively worked on configuring, monitoring, and troubleshooting the SQL Server high availability solutions AlwaysOn, clustering, mirroring and replication. Installed the 4 node clusters on SQL Server 2012.
• Successfully migrated SQL Servers from 2005/2008/2008 R2 versions to 2012/2014 in enterprise data centers.
• Installed, deployed, administered 115 SQL Servers 2005/2008/2008 R 2/2012/2014/2016 on 64-bit/32-bit environment with hosting the high-volume databases sizes up to 3.6 TB. Installed centsOS linux servers.
• Has effectively communicated with application teams to use slave server (MySQL) for all select queries being executed for application reporting needs. Implemented federated, NDB and archive engine tables in MySQL.
• Monitored prod MySQL, PostgreSQL servers using shell scripts, configured automated dumps via cron jobs.
• Mastered MySQL Backup technologies mysqldump, xtrabackup, lvmsnapshot, coldbackups and implemented partial backups loading from xtrabackup full backups in Percona 5.5 and 5.6 and MySQl 5.6.
• Has enabled slow query log and configured log rotate scripts for purging slow query logs via cron jobs.
• Installed validate password plugin, configured password policy by editing the my.cnf file using VI command.
• Worked extensively on applying services packs for Database engine, SSIS, SSRS and SSAS servers.
• Had optimized the slow running queries in SQL Server by creating & reorganizing indexes, using profiler to take SQL traces and mastered performance tuning at the database level & Server level.
• Successfully performed the Load shift activity from production to staging environment which is done every quarter for all of the mission critical databases in the MySQL and SQL Server landscape.
• Imported data from MySql 5.6 to SQL Server 2014 using SSIS packages for the enterprise data warehouse (EDW) project. Installed SQL Server Analysis Services (SSAS) in Multidimensional and Data Mining Mode.
• Configured InnoDB print all deadlocks, event scheduler variables to ON status for viewing all of the past deadlocks and executing tasks as scheduled events. Has insight of auto-sharding, in-memory HA environment.
• Worked exclusively on auditing of SQL Server at server level and database level (CDC (change data capture) for DML and DDL triggers). Monitored SQL Server Browser service on stand-alone and clustered instances.
• Performed the backups and restore for the transparent data encryption (TDE) enabled SQL Server databases.
• Worked exclusively on SQL Server analysis services (SSAS) by creating, maintaining the SSAS databases and cubes and configuring the security for them. Has operational knowledge of AWS-RDS.
• Migrated the mission critical database scripts to the production MySQL servers after 5 PM PDT via GUI MySQL tool SQLyog. For the SQL Servers, management studio was used. Reset the linux users passwords.
• Has configured group concat max len variable to a higher value than default 1024 value to avoid the "row ***** was cut by GROUP CONCAT ()" error while executing scripts. Configured users on linux servers.
• Implemented test restores quarterly on DR servers of SQL Server, MySQL for all mission critical databases.
• Has installed clustered SQL Server 2014 servers for the development, production environments and has a firm understanding of the new features like In-Memory OLTP, Updateable columnstore indexes, Delayed durability, Incremental statistics, Lock priority of online operations and Cloud features.
• Resolved low disk space issues on mysqltmp directory, implemented capacity planning of new MySQL servers.
• Created, monitored linked servers on SQL Servers for numerous data sources including but not limited to Oracle, MySql, MS Access and DB2. Configured pg hba file on PostgreSQL servers for application users.
• Has assisted application teams in building new PostgreSQL, SQL Servers, MySQL servers, databases and replicating production databases to lower environments (QA, DEV, CI (Customer Integration) & Staging) by backups/restores. used pg isready monitoring tool, EnterpriseDB Postgres Advanced & Standard Servers.
• Worked exclusively on SQL Server profiler, database engine tuning advisor(DTA), query execution plans, PerfMon in performance tuning. Performed backups and restore for transparent data encryption (TDE) enabled databases.
• Created jobs with SSIS packages on SQL Server agent for the ETL needs and index maintenance of the mission critical SQL Server databases.
• By installing the appropriate drivers configured and installed the Oracle SQL developer tool for accessing the SQL Server databases for access to the application teams.
• As a DBA manager for team of 4 DBA’s provided technology vision & roadmap aligning with business strategies. Architected, implemented 3 business critical multi-million dollar projects (data center migration, upgrades, automation) for database infrastructure. Saved $1.5M in licenses for SQL Server, MySQL servers.

Confidential, Washington, DC

Senior DBA MySQL

Responsibilities:

• As a senior database administrator (production support DBA & application DBA) for world bank in a team of 5 DBA’s has deployed, administered 115 MySQL/MariaDB/Percona servers, 90 PostgreSQL, 210 SQL 2000 to 2014 servers on 64-bit/32-bit environment hosting high-volume databases sizes up to 3.6 TB.
• Installed, upgraded MySQL servers from 5.0,5.1 to 5.5/5.6. Configured, maintained replication setups (M-S, M-M), MySQL/MariaDB Galera/Percona clustering (INNODB). Worked with monitoring tools Nagios XI, Cacti.
• Worked extensively on MySQL utilities (mysqldiff,mysqldiskusage,mysqlrpladmin) by downloading from MySQL Workbench and has extensive experience with Percona toolkit (pt-table-sync,pt-table-checksum,pt-online-schema-change). Implemented federated and archive engine tables in MySQL.
• Worked with different MySQL storage engines like Myisam, InnoDB, Archive and Federated.
• Monitored, installed PostgreSQL servers. Administered via phpPgAdmin, pgAdmin. Configured connection pooling, load balancing with Pgpool-II. Performed backups/restores via pg dump, psql.
• Worked extensively on applying services packs for SQL Server Database engine, SSIS, SSRS and SSAS servers.
• For PostgreSQL servers, configured asynchronous and synchronous cascading streaming replication. Used Repmgr for monitoring them. Worked on Ora2pg tool for migrating Oracle databases to PostgreSQL.
• Successfully performed the Load shift activity which is done twice a year for all the mission critical databases in the two data centers and supported Oracle E-Business Suite(EBS) teams MySQL databases.
• Successfully migrated SQL Servers from 2005/2008/2008 R2 versions to 2012/2014 in enterprise data centers.
• Used the monitoring tool Spotlight to monitor, diagnose and resolve database performance issues for highly mission critical SQL instances. Worked on the on-call rotation twice a month on every alternate week.
• Has worked on installing, administering, configuring, monitoring & architecting 5 TB Apache Cassandra 2.1/2.2 database servers on a multi-datacenter cluster.
• Has operational knowledge of high volume (4.6 TB) Time series databases(TSDB) Blueflood, KairosDB, NewtsTime on Cassandra architecture
• Installed the SQL Server Analysis Services (SSAS) in the Multidimensional and Data Mining Mode
• Mastered the production support and application development of SharePoint applications by providing the backups/restores of wss content databases and resolving the performance issues.
• Has supported the epic application team by providing by providing the backups and restores for the epic clarity warehouse databases. Worked exclusively with VMWare tool VMWare vSphere client 4.1/5.1/5.5.
• Installed the Database Engine (Stand alone and cluster, mysql clustered), Integration services and Reporting services for the clients as per the standard procedural guidelines.
• Worked exclusively on auditing of SQL Server at server level and database level (CDC (change data capture) for DML and DDL, DDL triggers)
• Performed backups and restore for the transparent data encryption (TDE) enabled databases.
• Interaction with the windows team for requests for installing the .NET frame work 3.5 while installing the SQL Server 2012 DB engine, SSIS, SSRS and SSAS. Imported data from MySql to SQL Server 2014 using SSIS.
• Worked exclusively on SQL Server analysis services (SSAS) by creating, maintaining the SSAS databases and cubes and configuring the security for them.
• Maintained efficient and fault proof disaster recovery plans by taking the backups and restoring using the Confidential Tivoli storage manager (TSM backups and restores). The retention period is 90 days.
• Has worked extensively on compressed backups, online index creations, MySQL clusters (INNODB)
• Has implemented the test restores on the DR server for all mission critical databases for every quarter.
• Has extensively worked on installing, configuring, monitoring and troubleshooting the high availability solutions clustering, mirroring and replication. Installed the 4 node clusters on SQL Server 2012.
• Has migrated on-premises SQL Server 2008R2 databases to SQL Azure for Microsoft dynamics CRM SaaS application (Montera) by using SQL Server Integration Services (SSIS). Has operational knowledge of AWS-RDS
• Has installed stand-alone SQL Server 2014 servers for the development, production environments and has a firm understanding of the new features like In-Memory OLTP, Updateable columnstore indexes, Delayed durability, Incremental statistics, Lock priority of online operations and Cloud features.
• Implemented the restores of SQL Azure databases for Montera’s SaaS application with a clear understanding of the backup retention periods of the Azure databases as per their service tiers.
• Performed the point-in-time restores and Geo-restores of the SQL Azure databases using the Azure management portal for the Microsoft dynamics CRM SaaS application
• Used the Database copy wizard to copy databases to new databases on the same server via the Azure Management Portal for Montera SaaS application team. Has worked in Openstack cloud environment.
• Proactively monitored the production/development servers in the SQL Server farm by checking the daily reports generated by the SolarWinds Orion SAM (Server and application monitor) monitoring tool.
• Resolved the disk space alerts, SQL clusters running on wrong nodes alerts, orphaned user’s alerts, failed backups alerts, database offline alerts, job failed alerts, Tempdb disk space utilization alerts, wrong recovery model alerts, xp cmdshell enabled alerts, SQL Server Service stopped alerts by checking the daily, weekly and monthly reports generated by the SolarWinds Orion SAM monitoring tool.
• Has developed scripts to fix the vulnerabilities displayed by the OIS scan tool for the mission critical databases and instances in the SQL Server landscape and implemented the resolutions by effectively executing the scripts after internal meetings and approvals within the team.
• Has worked proactively with the firewall team and Trend Micro Deep Security Agent tool for providing access to the SQL Server databases, Instances, SSAS, SSRS and SSIS servers for the application teams. The OS level access to all of the servers in the SQL Server farm are maintained, monitored by the firewall team and only the approved IP’s of the clients are allowed to access the database servers
• Has attended official training sessions from MongoDB Company for the administration of MongoDB databases in the enterprise environment.

Confidential, Towson, MD

Senior SQL Server DBA

Responsibilities:

• As a senior SQL Server database administrator (production support DBA & application DBA) in a team of 10 DBA’s has deployed, administered, monitored 195 SQL 2000/ 2005/2008/2008 R2/2012 servers on 64-bit/32-bit environment with hosting the high-volume databases sizes up to 3.9 TB.
• Worked extensively on the database backup/restore tool COMMVAULT galaxy for taking the backups and restoring of the SQL Server 2012/2008R2/2005/2000 databases.
• Worked on the job scheduling tool AUTOSYS for scheduling the jobs for backups, restores, weekly maintenance tasks like Index rebuilds using the JIL files.
• Scheduled backup jobs on SQL server express editions by windows task scheduler tool for all of the Shavlik servers where the enterprise IT management tool Shavlik is installed.
• Resolved the TEMPDB performance issues. Monitoring and troubleshooting the log space of the TEMPDB database was a regular production support task.
• Moved production BI data & dev data between different file groups to resolve the space and database performance issues. Monitored SQL Server Browser service on stand-alone and clustered instances.
• Installed & configured the 4 node cluster for the new SQL Server 2012 servers in the production and development environment. Used Robocopy to copy huge files over the network.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Worked on Microsoft Active Directory Services.
• Worked exclusively on auditing of SQL Server at server level and database level (CDC (change data capture) for DML and DDL, DDL triggers)
• Identify and resolve database performance issues, database capacity issues.
• Effectively resolved the low disk space issues for the production and development/test servers by resizing the log and data files. The low disk space issues for drives where the program files are installed are resolved by recycling the error log file which grew in size very large.
• Has worked on SQL Server AlwaysOn high availability feature and has a firm understanding of the Contained Databases and Availability groups(HADR) of SQL Server 2012
• Defined different server groups for the production, training and test instances by using the Central management servers and validated the versions of instances by running a single query against multiple instances in a particular group.
• Worked on the 480 DCO (Data centre optimization) project for migrating the databases from 2000, 2005, 2008 servers to 2008R2 and 2012 servers. The migration and upgrade also included the databases in the VMware environment. Worked and resolved issues on Full text search catalogs.
• Worked extensively with SQL profiler, database engine tuning advisor for tuning queries using variables for characteristics and query costs. Used numerous customized templates for getting the traces.
• Mastered the performance tuning at the server level, operating system level and at the database level of which using with recompile option was one among the many.
• Worked on CREATE TYPE functionality and encrypted critical table columns containing sensitive data using SQL Server 2005 and 2008 by creating symmetric and asymmetric keys
• Worked with the function NEWID(), encryption methodology by configuring the certificates and master keys for the sql server databases
• Has done the installation of SQL Server express editions (2012 and 2008R2) and enabled the default TCP/IP port and service broker. Performed the unattended installations of the client tools for SQL Server 2012 and 2008R2. The client tools that were installed were SQL Server management studio, Business intelligence development studio and Data tools.
• Trouble shooting the Clustered instances due to the cluster service failover and network inconsistency issues.
• Experience in index tuning and performance optimization techniques
• Monitored and modified Performance using execution plans and client statistics
• Configured the linked servers on the production and development instances to retrieve data from multiple instances which had legacy data and from third party applications having Confidential /AS400 databases.
• Worked on resolving the performance issues for the content databases of the share point applications and supported the SharePoint application teams by maintaining the concerned SQL server databases
• Operational support for SQL Server Report services (SSRS) by creating the data sources, creating the logins for the appropriate reporting services databases and manually moving the reports from 2005 databases to 2008R2 and 2012 databases.
• Had installed SSRS and SP2 on clustered instances. The SSRS installation was done via the command prompt to skip the installation rule check process
• Designed the databases for the reporting functionality of the reporting team
• Migrated the SSIS packages from SQL Server 2005/2008 to 2008R2 and 2012 servers
• Worked on the high availability solution mirroring by supporting in the development environment.
• Has installed AccessDatabaseEngine2010 driver on the production servers to run the SSIS packages which transfers the data from MS Office applications
• Had setup database mail for the production and development servers and installed SQL Server ODBC drivers for the 2012 and 2008R2 servers. Installed the oracle client for windows.
• Mastered the performance tuning of the databases for the VMWare VCenter application.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies such as Mirrored backups/restores, striped backups/restores in scenarios where we were having low disk space issues.
• Configured and monitored transactional replication for the mission critical production databases
• Installed the tool DBAmp on the windows servers for integrating the Salesforce application as a linked server with the SQL Server databases.
• Worked on granting limited access to the xp cmdshell for non-sysadmins and resolved the database issues for the OCS (Office Communications Server 2007 R2) application during its upgrade.
• Tested the disk subsystems for the newly built SQL Server 2008R2 and SQL Server 2012 servers for the I/O activity and load performance by using the SQLIO and SQLIOSIM tools.
• Worked extensively on SCOM tool to actively read the alerts from the SQL instances and windows servers
• Has extensively used Microsoft SQL Server Migration Assistant (SSMA) v5.3 for migrating the oracle and MySql databases to SQL Server 2012 and SQL Server 2008R2
• Imported data from MySql to SQL Server 2012 using SSIS
• Supported the SAP teams by providing the backups, creating logins and fine tuning the stored procedures for the SQL server databases at the backend.
• Worked on ServiceNow ticketing system for documenting the change management and problem management of the production and dev/test database servers.
• Attended seminars on SQL Server 2014 and has a firm understanding of the new features like In-Memory OLTP, Updateable columnstore indexes, Delayed durability, Incremental statistics and Lock priority of online operations.

Confidential, Richmond, VA

Lead SQL Server DBA/Architect

Responsibilities:

• AS a lead database administrator, architect and IIS administrator for a team of 3 DBA’s and 1 IIS admin has deployed, administered, monitored 11 SQL 2000/ 2005/2008/2008 R2/2012 servers on 64-bit/32-bit environment hosting the high-volume databases sizes up to 1 TB.
• Used SQL IDERA diagnostic manager to monitor, diagnose and resolve database performance issues for highly mission critical SQL instances
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Worked on Microsoft Active Directory Services
• Worked exclusively on auditing of SQL Server at server level and database level (CDC (change data capture) for DML and DDL, DDL triggers).
• Monitored and modified Performance using execution plans and building the indexes using the Database engine tuning advisor (DTA). Maintained database consistency with DBCC at regular intervals.
• Defined different server groups for the production, training and test instances by using the Central management servers and validated the versions of instances by running a single query against multiple instances in a particular group.
• Worked on the TEMPDB performance issues, monitored and troubleshooted the TEMPDB database on a regular basis. Identify and resolve database performance issues, database capacity issues.
• Worked extensively with SQL profiler for tuning queries using variable for characteristics and query costs.
• Fine tuned the stored procedures and views by recommending to the development teams to use the NOLOCK after every table, to use the MEGRE statement instead of insert, update and delete statements.
• Worked exclusively on the pivot tables, macros and data connections features in MS Excel.
• Encrypted critical table columns containing sensitive data using SQL Server 2005 and 2008 by creating symmetric and asymmetric keys
• Implemented & managed 3 node Active-Active-Passive clustering, failover and load balance technologies as per client requirement
• Maintained the High Availability solution Mirroring as a database disaster recovery technique and Rebuilding the indexes once in every 2 days on the principal database for better performance by monitoring the transaction logs carefully
• Efficiently implemented the daily and the hourly snapshots(Read only) of the principal database on the training/development instance
• Trouble shooting the Clustered instances due to the cluster service failover and network inconsistency issues.
• Experience in index tuning and performance optimization techniques
• Monitored and modified Performance using execution plans and client statistics
• Deployed and administered the training and development web-based applications using IIS
• Troubleshooting website unavailability issues by IISRESET command and by starting the stopped application pools of corresponding websites. Created, managed domains on IIS7. Monitored event viewer, IIS logs for errors.
• Configured the linked servers on the production and training instances to retrieve data from multiple instances which had legacy data
• Operational support for SQL Server Reporting services (SSRS) by creating the data sources for appropriate databases. Migrated MS SQL Server 2008 R2 databases in VMware environment.
• As a report writer designed databases for reporting functionality of the reporting team and generated reports. Exclusively supported application deployment on IIS server.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Navigated entire data traffic of reporting team to the hourly snapshots for retrieving up to date reports thereby removing the load from principal production database and thereby improving the performance.
• Configured and managed transactional and merge replication for the mission critical production databases
• Configured the VMWare work stations for the Test environments.
• Maintained the integrity of data by designing and implementing the data dictionary for the mission critical production and development databases.
• Worked with the spatial data which includes geography datatype and spatial reference identifiers (SRIDs)
• Maintenance and troubleshooting of Citrix Server XenApp 4.5 running 12 Windows 2008R2 servers
• Worked extensively on SCOM tool to actively read the alerts from the SQL instances and the windows servers
• Responsible for 140 users as third level support of 18 applications on Xenapp 4.5
• Worked on configuring the users on Citrix by the FOB key for accessing various applications hosted on the Citrix environment, troubleshooting the login access issues to the Citrix by resetting the Citrix password and enabling the disabled Citrix account.

Confidential, Hopkins, MN

DBA MySQL

Responsibilities:

• As an Application DBA for the Tartan Project in Tartan Data and cut over team has managed 19 MySQL servers, 10 PostgreSQL, 54 SQL Servers hosting high volume databases sizes of 2.4 TB.
• Worked on installing and upgrading MySQL servers from 5.0, 5.1 to 5.5, PostgreSQL from 8.4 to 9.1.
• Extensive experience in configuring, creating MySQL databases and configuring Mysql-zrm backups.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Performed PostgreSQL backups/restores via pg dump, psql. Monitored cascading streaming replication on PostgreSQL servers. Worked on Ora2pg tool for migrating Oracle databases to PostgreSQL.
• Migrated DTS packages from the development server to the production server and migrated the DTS packages to SSIS packages. Monitored and fine-tuned ETL jobs daily using BCP and DTSRUN.
• Experience in Transparent Data Encryption(TDE) to encrypt an entire SQL Server database for Security
• Migrated MS SQL Server 2000/2005 databases to SQL Server 2008 in VMware environment
• Migrated the data from legacy applications to the SQL Server databases hosting the SAP application via the DataGarage, EZMap, BDCDirect, Cranport, DataStagingWarehouse functionality of the Cransoft tool
• Monitor/Maintain the highly transactional servers that process 300 batches for every 5 seconds on an average. Maintaining the database consistency with DBCC at regular intervals.
• Experience in index tuning and performance optimization techniques. Maintained integrity of data by designing and implementing data dictionary for mission critical production and development databases.
• Administered multiple servers by configuring and using the Central management server feature
• Deployed and administered nearly 50 SQL 2005/2008 R2 servers on 64-bit/32-bit environment.
• Proactively monitored Production Server and optimized stored procedures for better performance Resolve locking conflicts and resource utilization. Setup MOM monitoring alerts for monitoring all SQL Server boxes.
• Extensively used the SQL LITESPEED tool by the Quest Software to restore the backups at object level for tables and at schema level and rebuilding the indexes at regular intervals for better performance
• Encrypted critical table columns containing sensitive data using SQL Server 2005 and 2008 by creating symmetric and asymmetric keys. Extensively worked on Microsoft Active Directory Services.
• Used the exclusively database driven tool CranSoft to develop web applications with the backend as SQLServer 2005. Experience with Snapshots for backups using EMC Timefinder.
• Experience with Visual Studio 2010 using Team Foundation Server. Experience in the use of Microsoft AJAX development tool and creation of process flow diagrams in Microsoft Visio. used the tool BMC Remedy user by the BMC software in resolving the incidents in the development servers and the production servers. Has started, stopped, paused, resumed and restarted BizTalk Server Services. worked on configuration management extensively to design the configuration management database(CMDB) and configuration Items(CI's)
• Performed SQL DBA activities on mission critical SQL Databases on which SAP ECC 6.0 was hosted
• Experience in Sybase migrations involving the Sybase IQ column oriented RDBMS
• Has created and maintained load jobs using Bteq, Fastload and Mload for the TeraData databases
• Has migrated stored procedures, functions, triggers, database schema (DDL), BTEQ scripts from TeraData to SQL Server 2008/2008R2. Querying the databases using the PowerShell scripts.
• Using the CranSoft tool interface indexed several columns in the database through the domain specific key words, used the chart option and worked on multi-lingual settings for different geographical locations of the business as a CranSoft administrator
• Has performed IIS 5x, 6x installation, configuration and Tuning. Created & managed domains on IIS.
• Convert MS Access database to SQL Database and generate reports from the MS Access databases
• Monitoring SQL server performance using profiler to find performance and dead locks and blockings
• Working and utilizing DMV’s in SQL Server 2005 & SQL Server 2008 R2 for tuning and optimizing the servers.
• Worked with Linked Servers and OPENQUERY to retrieve the Oracle data into SQL Server 2005.
• Worked with the spatial data which includes geography data type and spatial reference identifiers (SRIDs)
• Experience in Installing and configuring MS SQL Cluster Servers in Active/Passive and Active/Active environment. Managed/administered the file groups for data, index and read-only for VLDB’s.
• Evaluated data storage considerations to store databases and transaction logs. Worked together with Architects and technology specialists to design database, clustering, upgrades and migrations and implemented various RAID levels on SAN Storage for file placements to improve the performance of servers
• Assisted the development teams in installing MS SharePoint version 2007 and upgrading the SharePoint application from MS SharePoint version 2007 to 2010.
• Developed and implemented Transactional Replication, Archiving, Backup and Recovery strategies.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Tuned, monitored, maintained & Scheduled SQL Server Jobs.

Confidential, Burbank, CA

Lead DBA MySQL

Responsibilities:

• As a lead production support DBA has deployed and administered 110 MySQL servers, 27 PostgreSQL, 320 SQL 2000/ 2005/2008/2008 R2 servers on 64-bit/32-bit environment hosting high volume databases of sizes up to 2.9 TB.
• Used Embarcadero Rapid SQL, Embarcadero DBArtisan for intuitive SQL editing and debugging. Worked with the optimization tools to create high performance SQL code
• Installed various MySQL versions on centOS/Red Hat Linux with Perl modules, configured replication (binlog).
• Worked with different MySQL storage engines like Myisam, InnoDB, Archive and Federated.
• Used the third-party tool CranSoft of Back office associates in the production environment on the SQLServer 2000 and SQLServer 2005.
• Exclusively used the CranSoft web application interface for data migration, data extraction and generating reports. Monitored and fine-tuned ETL jobs daily using BCP, DTSRUN and SSIS .
• Extensive experience in MySQL server health performance check and expertise in shell scripting, MySQL query analysis and tuning. Have traced the root causes for MySQL crashes and fixed the root cause using stack trace. Experience with MySQL monitoring tools Cacti and OpenTSDB.
• Monitored the master - slave sync using pt-table-checksum in MySQL.
• Installed PostgreSQL on Linux servers & configured streaming replication. Performed backups/restores via pg dump & psql, PITR (Point-in-time restores) by enabling write ahead log(WAL) archiving
• Exclusively worked on informatica with the tools Power center designer, Power center workflow monitor, Power center workflow manager and Power center repository manager in creating the sessions, mappings, workflows and work lets.
• Maintained High Availability such as Log Shipping and Mirroring as a database disaster recovery technique.
• Created Database Maintenance Plans for optimum performance of SQL SERVER, which covers Database Integrity Checks, Update Database Statistics and Re-indexing. Maintained database consistency with DBCC at regular intervals. Used powershell scripting to get most consistent production environment.
• Provided production support for the custom and COTS systems which was a SaaS implementation.
• Migrated MS SQL Server 2000/2005 to 2008 R2 databases in VMware(Vblock) environment
• Efficient response to database events in production environment & performance monitoring in fail-over cluster administration of mission critical databases for SQL Server 2008 R2.
• Experience in performance tuning and monitoring SQL 2005/2008/2008 R2 databases within SAP architecture
• Provided the application support 24/7 to the applications and delivered enhancements and customizations.
• Assisted the production support of DB2 v9.x on Linux/AIX in production and Staging environments.
• Identify and resolve database performance & database capacity issues for SQL Server, MySQL, PostgreSQL.
• Has performed the Backup and Restore using great plains DYNAMICS database
• Has familiarity with great Plains tables architecture and performed extensive Data querying with Microsoft great plains using the Report Writer. Has performed the installation and monitored the Service Broker
• Has deployed IIS. Effectively administered web-based email applications, supported application deployment on IIS server. Experience with iText.NET on .NET framework for generating PDF, HTML and XML files.
• Migrated Confidential DB2 v8.2 databases to SQL Server 2005/2008R2 for Visual Studio and .NET Developers.
• Has troubleshoot operations console connections by installing Service pack for iSeries Access for Windows.
• Has created and maintained load jobs using Bteq, Fastload and Mload for the TeraData databases.
• As per the Common Auditor Requirements of SOX Monitored access failures and schema changes
• Has created reports in SSRS using legacy MS access databases. Has created illustration tasks using Visio to create flowcharts and technical diagrams for patent applications and other documents.
• Worked on the SaaS implementation of ticketing system change management tool Service Center in resolving the issues on the production, test and development servers.
• Implemented, managed SQL database clustering and load balance technologies as per client requirement
• Has a firm understanding of the Double take tool for disaster recovery solutions and CommVault enterprise tool for taking the backups and recovery of the databases
• Provided an estimation of the migration and upgrade plan in terms of feasibility, time duration and resources
• Ensure all database environments (Development, Staging, QA and Production) are in sync. Defined db scripts versioning system to keep track of database versions for all environments.
• Made database back up using SQL Litespeed (Full, Differential, Log and File group back up) and restore it
• Worked on security and audit requirements using the third party application of SAS70 systems
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of company's databases. Developed database maintenance plan for Data warehouse environment.
• Applied patches to the applications on the front end which had the ETL tool informatica on the back end
• Scheduled jobs on SQL Server 2000 and upgraded SQL Server 2005 to 2008 R2 in production environments
• Worked on SQL Server Query Notification with BizTalk Server 2009 WCF SQL Adapter
• Involved in extensive knowledge transfer sessions to know the database recovery strategy used, the high availability solutions implemented and successfully coordinated with the off shore team
• Upgraded the front end applications to the latest versions based on the software provided by the vendor
• Gained the trust and confidence of the prestigious client