SUMMARY

• Have over 12 years of focused experiences in IT industry in various fields like financial and manufacturing. Extensive experiences in Microsoft SQL Server and open sourced database such as MySQL design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Comprehensive experience as senior MS SQL Server DBA; proficient in MS SQL Server 2005/2008/2008R2/2012/2014 software installations, migrations, database capacity planning, automated backup implementation, performance tuning. Involved with the architect group in designing the logical and physical model of the enterprise level databases. Have solid experiences in both Windows and Linux/Unix administration, Powershell / Korn shell / Perl scripting.
• Have impeccable communication and interpersonal skills and an exceptional team player.
• Professional and highly motivated, having over 5+ years of MySQL DBA and development work experience in the software industry with MySQL(4.x,5,x).
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation, upgrade, migration.
• Have successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.
• Strong MySQL skills but also significant general system administration skills on UNIX/Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Experience in the administration of Web based Internet/Intranet Client/Server multi - tire distributed application, major in database technologies in Consulting, Sales & Finance, Manufacturing & Standards domains.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on MySQL databases.
• Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, database optimization with the help of explain plan.
• Expertise in database migration from MyISAM format to InnoDB storage engine to increase performance and betterment of integrity constraints.
• Strong experience in Data modeling and their different tools like Oracle Designer, Power Designer, Erwin, MS Visio and DDT.
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of Database as well as frontend. With different project development model like SDLC, Agile, SCRUM etc.
• Experienced in writing shell scripting, Perl script for Linux/Unix.
• Good analytical, problem-solving skills, verbal and written communication skills.

TECHNICAL SKILLS

Database: MS SQL Server 2000/2005/2008/2008R2/2012/2014, MySQL 5.0/ 5.1 / 5.5 / 5.6, Oracle 10g/11g, Cassandra, MongoDB

Languages: SQL, PHP, Shell, HTML, CSS, XML, C/C++/C#, Java, Perl, Javascript

Tools: SSRS/SSAS/SSIS, Profiler, Performance Monitor; SQLyog, Visual Studio/ SharePoint

Application: Apache/IIS/Tomcat, SVN, FTP, Samba, DNS, Firewall, VPN, VMware

Windows System: XP/Vista/Win7/2003/2008/2008R2/2012, Exchange 2007, Office 2007/2010

Linux/Unix System: Redhat Linux, Fedora Core, Gentoo, CentOS, FreeBSD/OpenBSD

PROFESSIONAL EXPERIENCE

Confidential

Microsoft SQL Server Experience

Responsibilities:

• More than ten years’ working experience in Microsoft SQL Server database administration, including SQL Server 2005, 2008, 2008R2, 2012, 2014.
• Extensive experience including designing, implementing, maintaining, and documenting complex database applications and data warehouse.
• Solid first-hand experience with Data modeling and Database Logical /physical Design.
• Strong experiences with server clustering, data warehousing, data extraction/transformation/load.
• High skills with MS SQL Server Log shipping, Database Mirroring, snapshot/transactional/Merge replication, Failover cluster, BCP, DTS and SSIS, SSAS and SSRS.
• Experience with MS SQL based reporting tools like Crystal Reports and SSRS.
• Develop and implement policies, procedures and standards for preserving the integrity and security of data, reports and access.
• Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Profiler, Performance Monitor.
• Experience with installing, configuring, analyzing, and supporting SQL Server 2000, 2005, 2008, 2008R2 and 2012 in Development, Test and Production Environment
• Strong experience with MS SQL Server upgrade, full / differential / log backup & recovery, clustered/non-clustered index, locks including live locks/dead locks
• Extensive experience with writing SQL scripts, stored procedures, triggers and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
• Strong experience with server/database/scripts Performance tuning and optimization.
• Experience with monitoring, troubleshooting and resolving database issues in 24×7 production server.
• Strong experience with MS SQL Server performance monitor and performance tuning
• Strong experience with database maintenance and MS SQL Server version upgrade.
• Excellent knowledge with SAN Storage and Storage Capacity Planning.
• Experience with establishing and maintaining development, testing and production environments.
• Experience with Visual Studio and Microsoft SharePoint platform.
• Good Knowledge of system monitoring software (Zabbix/Nagios/Solarwinds)
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks.
• Excellent communication skills. Proactive, independent, self-managing and teamwork spirits.
• Experienced on 7X24 On-call Service.
• Experience with Sox 404 Auditing and PCI compliance.
• Good OS skills in both Windows and Linux/Unix platform.
• MySQL Experience (5+ years

PROFESSIONAL EXPERIENCES

Confidential, Sunnyvale, CA

Tech Yahoo MySQL DBA (Consultant)

Responsibilities:

• Providing expert advice and direction in MySQL which includes database Administration, High Availability MySQL, database design and development for system solutions.
• Deploy/Install/Configure In-house LAMP stack for corporate application.
• Implement 24/7 monitoring solution for various application services and database.
• Debug all application issues (Apache, MySQL Percona, MS SQL 2008 R2/2012 ). Monitor database logs and drive to conclusion by suggesting/implementing solutions.
• Support team members migrating physical machines to VMware virtual machines on development and production MySQL Percona 5.6 servers
• Investigate MySQL slow query log, fine tune SQL query to improve query performance.
• Help monitoring over 100+ departmental MySQL servers using in-house monitoring tools, investigate any errors and alerts, fix the problems accordingly.
• Apply security patches on MySQL servers and update MySQL 5.3 to 5.6 version.
• Documenting MySQL database migration procedures.

Confidential, Atlanta, GA

Sr. MS SQL Server DBA and MySQL DBA (Consultant)

Responsibilities:

• Managed and Optimized more than 50 MSSQL Servers (SQL Server 2005/2008/2008R2/2012) and more than 30 MySQL X64/Redhat Linux boxes setup and managed high availability strategy: failover cluster, replication, database mirroring and log shipping
• Set up and managed MySQL Master to Master replication, Master to Slave replication and MySQL Sharding
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics
• Wrote Shell Scripts and setup cron to automatically back up MySQL Databases in Linux System
• Collaborated with infrastructure team for database backup strategy: onsite backup, offsite backup and offline backup
• Used SQL Server Profiler to trace long running queries for optimizing databases
• Optimized MySQL InnoDB database Engine
• Restored MSSQL Backups and MySQL Backups to check backup integrity and practice disaster recovery
• Troubleshot SQL Server related CPU/Memory, I/O using Performance Monitor
• Troubleshot MySQL issues and optimized MySQL performance through slow query log and execution plan.
• Wrote MSSQL codes including stored procedures, functions, and triggers.
• Wrote MySQL procedures and ad hoc queries.
• Managed MSSQL data warehouse, Wrote SSIS for ETL tools, SSAS for data analysis, SSRS for reports.
• Collaborated with system teams and development teams for codes release including MSSQL and MySQL database changes and patches.
• Set up and configure Zabbix Confidential and Solarwinds to monitor SQL Server system, MySQL system, Windows Application systems and Linux systems.
• Upgraded MySQL from lower version 5.1 to higher version 5.5/5.6.
• Upgraded SQL Server 2005 to SQL Server 2008R2, SQL Server 2008R2 to SQL Server 2012.
• Created and managed full-text server, linked servers to support production needs.
• Documented All MSSQL Database and MySQL database structures and functionalities.
• Worked with Auditors and Provided Database related documents.
• Worked on 7X24 on-call rotation.

Confidential, Charlotte, NC

Sr. Microsoft SQL Server DBA (Consultant)

Responsibilities:

• Worked closely with Systems Administrators and Development teams to Administer - install, upgrade, migrate and troubleshoot Prod and non-prod SQL server instances across both physical and virtual machine (VMware) environments
• Administered over 50+ SQL servers
• Migrated several PROD database servers with minimal downtime
• Supported reporting applications, and other sub systems dependent on SQL server
• Monitor production databases for performance, availability and data integrity
• Configure and maintain database replication, log shipping and nightly processes
• Scripted several database maintenance tasks reducing manual processes and related overheads
• Performed data recovery from corrupt databases or simple backups or transaction logs
• Set up SQL/database mail to produce database health reports and other alerts
• Managed production deployments of schema changes and data conversions
• Created SSIS packages for data transfers, Import/Export and Migrations
• Recreated indexes, optimized queries, memory management to improve performance
• Database space management, log files and data integrity
• Created and managed full-text server, linked servers to support production needs
• Administered SQL server security and kept up-to-date through frequent audits of SQL logins
• Tested and installed latest SQL server / Windows server service packs on all SQL servers
• Integrated SQL Server with Windows Active directory security for database/table level permissions
• Created strong passwords for SA account, sometimes disabled it, remove sample databases
• Ran Microsoft Baseline security analyzer periodically to check for SQL server security issues
• Worked on database maintenance (including DB changes, DB patch, DB index tuning)
• Managed SAN system.
• Monitored Windows/Linux system using Nagios software
• Documented DB structures and functionalities

Confidential, OH

Microsoft SQL Server / MySQL DBA

Responsibilities:

• Managed and optimized more than 40 MSSQL Servers and more than 60 MySQL Servers (including Amazon RDS).
• Managed Global DBA team located in USA, Europe and Asia.
• Set up and managed IDC MSSQL/MySQL Server infrastructures and databases.
• Help setup data center including Racking Server, Cabling, IP-Planning, Firewall and OS.
• Installed and configured windows 2003/2008, and installed and configured SQL Server 2005/2008.
• Used Cassandra (NoSQL) to build user achievement system.
• Installed and configured Linux system and MySQL databases.
• Wrote stored procedures, functions, triggers by using T-SQL.
• Set up and managed SQL Server snapshot/transactional/merge replication, database mirroring, and Log Shipping.
• Set up and managed MySQL Master-Master replication, Master-Slave replication.
• Used maintenance plans to set up full/differential/log backup and periodically restored databases.
• Detected and troubleshot Server related CPU/memory, I/O using Performance Monitor.
• Periodically checked Index fragmentation and optimized index.
• Set up SQL Agent jobs, DTS and SSIS packages, and scheduled tasks to automate works.
• Provided day-to-day monitoring, troubleshooting, and performance tuning of all databases.
• Built and managed data warehouse, used SSIS for data processing, SSAS for data analysis, and SSRS for reports.
• Managed Dell SAN system.
• Designed database structures for user registration/billing/tacking systems.
• Documented Database structures and trained Junior MySQL DBA.
• Worked with auditors for SOX audit and PCI compliance.
• Used Zabbix software to monitor Windows / Linux system.

Confidential, San Jose, CA

Microsoft SQL Server & SSRS Report Developer

Responsibilities:

• Worked with Business Analysts on translating user’s requirements into development plan.
• Developed and built SSRS reports supporting more than 20 client company’s general business reports and benefit plan administration processes.
• Imported sales data to SQL Server database and create views for SSRS datasets.
• Created monthly KPI reports for different departments using pre-created stored procedures.
• Created and deployed Matrix, Grid, Chart and Gauge Reports using SSRS.
• Created parameters for SSRS reports with drill-down feature and interactive sorting capability.
• Integrated reports from SSRS with SharePoint and deployed reports and BI Dashboards to SharePoint.
• Created cubes that enable users to create pivot table in Excel using cube data.
• Generated SSRS reports with dynamic drill down features by configuring parameter.
• Created and configured database and tables with different constrains (PK, FK) as well as the database diagrams for documentation purpose.
• Loaded raw data from flat data files into SQL Server 2000 database tables using DTS package, bulk insert, and table export/import wizard.
• Established linked server to retrieve data from distributed SQL server, connected to diversified data source with OLE DB provider or ODBC provider.
• Created clustered index and non-clustered index to tables in order to improve query performance.
• Granted SQL Server Database security and Report Server security to end users.
• Integrated data from Heterogeneous data sources (Flat file, Excel, Access, Oracle, distributed SQL Server) to centralized SQL Server database using SSIS package (ETL), including data validation, data massage, transformation, data cleanse, formatting, mapping and auditing.
• Created Stored Procedures and views for ad hoc reports requirements.