SUMMARY:

• Years of experience in RDBMS field (MySQL server 4.x, 5.x, MS SQL6.5, 7.0,2000, 2005,2008), Oracle 7, 8i,9i, 11i).
• No SQL support, Cassandra
• Support production database systems 24x7 in high transactional, high data volume enviroment
• Mysql master - master, master-slave replication, auto fail over design and implementation
• Innodb,myisam, memory, xtradb, Percona 5.5, 5.6, 5.7, MariaDB 10.x, Galera Cluster
• Database performance tunning, table partitioning, db sharding
• Database logical and physical design and implementation
• Database application support (Web servers, PHP Apache ), various MySQL monitoring and manager tools
• Stored procedures, Functions,events, triggers, DTS, SSIS development and tuning
• Scripting language perl, shell, Python and java script

SPECIALTIES:

Third party Oracle managing tools: DBArtison, Quest Instance Monitor, Schema Manager, Foglight, Iwatch), and MS SQL Enterprise Manager, ODBC, JDBCOracle management tools Oracle Enterprise Manager, SQL* Plus, SQL*Net, Oracle Net8) Oracle tools (imp, exp, SQL*Loader,.

EXPERIENCE:

Database Architect

Confidential

Responsibilities:

• Database logical and physical design Cloud RDB implementation
• Data modeling, data flow design and implementation
• Database performance tuning, query tuning, RDBMS objects design Data Archiving, DB sharding, table partitioning Database DR and HA design and implementation
• Provide technical and lead database projects Automation, Shell, Python, Chef etc.

Staff Software Engineer

Confidential

Responsibilities:

• Database physical and logical design, data modeling, data warehouse design.
• Monitor and maintain 60+ databases servers
• Database performance tuning, query tuning, table partitioning.
• ETL, data mapping and migration
• Stored procedures, functions and triggers development database monitoring maintenance and troubleshooting
• Database servers high availability design and implement
• Data growth forecast and performance testing

Sr. Database Engineer

Confidential

Responsibilities:

• Database physical and logical design. Security policies design and implement MySQL 5.1, 5.5 setup, upgrade, maintaining, backup, troubleshooting MySQL/SQL server Performance monitor system setup, performance tuning, slow query tuning. Data Mining, ETL

Sr. Database Engineer

Confidential

Responsibilities:

• Manage MySQL, Microsoft SQL server monitoring, troubleshooting, performance tuning, high-availability strategies in a 24x7 production environment
• Design and implement databases on various RDBMS systems Linux and Window setup and administration Using various tools to monitor/admin.
• MySQL and MS SQL Develop and implement replication, cluster, archiving and backup and recovery strategies Hardware requirements and storage capacity planning for Development, Testing, QAStaging, and Production for scalable database growth and performance
• Proactively monitor the Production Database(s) and optimize stored procedures for better performance.
• Resolve locking conflicts and resource utilization Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases and systems
• Manage and Create database schemas for Relational Database Systems optimize index creation, table creation, storage allocations, etc
• Ensure all database environments Development; Testing, QA, Staging, and Production are in sync Design, review and implement production SQL Server database objects, models and database designs (schema)
• Identify and resolve database performance issues, database capacity issues and other distributed data issues

Database Administrator

Confidential, San Francisco, CA

Responsibilities:

• Support all databases (MS SQL and Mysql) in high availability environment-backup and restore, performance monitoring and tuning, troubleshooting various database related issues, develop database auto management tools
• Setup and maintain MS SQL server log shipping
• Develop SQL server DTS, stored procedures, functions to transform/update/report data
• Upgraded SQL server from, migrated/redeveloped all DTS to 2005 SSIS packages
• Setup and maintain SQL server cluster
• Make recommendations for hardware configuration for database servers
• Perform data reporting/data mapping using SQL
• Setup and manage SQL server Reporting Service
• Manage all production deployment efforts and all production related maintenance tasks(e.g. UAT database/data setup and maintains, DBCC, re-indexing, monitoring errors, etc.)
• Insure the up-time and optimal performance of multiple database Server environments using various tools

Database Administrator /Developer

Confidential

Responsibilities:

• Support Company’s database servers on 24x7 basis—backup and restore, performance Monitoring and tuning, database Management tools developement
• Design, implement and support company’s SQL 2000,7.0 and 6.5 Databases
• Data Modeling and Database designing
• Setup, upgrade, performance tuning and manage company’s databases
• Stored procedures, triggers and reports writing
• Worked on DTS package to move historical data from production server to data warehouse DB
• Sole Admin for company’s network and windows servers (2003, NT, exchange 2003)
• Support and develop company’s commercial website using ASP,VB and Java Script
• Upgraded Company’s NT network to Active Directory network

Database/Application Developer

Confidential, Sunnyvale, CA

Responsibilities:

• Design, implement and manage the product Engineering databases (MS SQL7.0, 2000)
• Installed and maintained SQL server replication
• Developed data analyze tools
• Graphic User Interface, Web page design and implementation using ASP and JavaScript
• Production data import programming using Java
• Implement and manage Backup and recovery systems, setup security gates and support department’s database servers and networks

Database Administrator

Confidential, San Francisco, CA

Responsibilities:

• Oracle Database Administration.
• Database management in a 24x7 high-availability environment; Install/Upgrade Oracle server software; Logical/Physical Oracle database design and implementation; Backup/recovery, monitoring, performance tuning, troubleshooting, accounts and security set up; other daily database management tasks.
• Worked as core member of Peoplesoft base team on all phases of implementation for Confidential first Peoplesoft system. From the beginning of Peoplesoft system planning to the successful production rollout.
• Peoplesoft System/database administration. Worked on installation, configuration and upgrading of Peoplesoft servers on Solaris 2.7 and Windows 2000. Installed and supported 12 databases for HR and Finance environment(for production, development and testing), running 24x7.
• Oracle Application Support. Supporting applications such as Remedy, Sieble, Vitria, Netserv; New application evaluation.
• Administrator for Company’s production MS SQL servers.
• Setup and administer SQL servers in 24x7 and high-availability environment; install and upgrade, backup/recovery, monitoring, performance tuning, troubleshooting, web reporting, accounts and security setup and other daily DBA tasks
• Netserv System Administration.
• Worked on installation, configuration, and upgrading of all Netserv systems; user setup/maintenance, security, job scheduling, VAN communications setup and maintenance; UUCP setup and maintenance; EDI message translation, WU-FTPD setup and maintenance.