SUMMARY:

• Proficient in IT Solutions, IT integration, MySQL/Oracle Administration with Unix, Windows and Linux, Database design and modeling, MySQL installation, Backup and Recovery, Performance and Tuning, MySQL Enterprise Monitor (MEM), Oracle Enterprise Manager (OEM), Oracle Fusion MIddleware, SQL, PL/SQL, J2EE, Java, Javascript, Servlets, JSP, ASP. Sharepoint Administration, Unix System Administration, Network (CISCO) Administration, Checkpoint (firewall) Administration, Windows Administration, Web Server Administration.
• Expertise in management and performance of very large Databases (MySQL/Oracle), administer Financial System (Oracle EBS R12), Data Warehouses and Database Designs.
• Quick learner with an ability to rapidly achieve organizational integration, assimilate job requirements and employ new methodologies. Energetic and self - motivated team player/builder. At ease in high stress environments requiring superior ability to effectively handle multi-task levels of responsibility.
• Excellent interpersonal, intuitive, analysis and leadership skills. Proven ability to work efficiently in both independent and team work environments. Known for exceeding goals and objectives.
• Experienced in developing and executing corporate policies and procedures. Proven track record for stimulating business growth, productivity, and decreasing overhead.

TECHNICAL SKILLS:

• MySQL Replication
• MEM
• RedHat
• Linux
• Solaris
• HP-UX
• IBM 3080s and IBM 3090s
• RISC/6000
• PS/2
• PC and compatibles
• APPLE
• RATIONAL
• SUN. CISCO ROUTERS
• RAID SYSTEMS
• NETAPP
• UNIX
• OS/VS
• OSF1
• VM/CMS
• VMS
• DOS
• OS/2
• XENIX
• SUSE
• TSO
• ISPF
• JCL
• WINDOWS 2005
• WINDOWS 2008. Tomcat
• Java
• C/C++
• PL/SQL
• X Windows/Motif
• Cobol
• Basic
• Fortran
• IBM 370 Assembler
• PL/1
• Natual/Adabas
• Sybase
• Oracle
• Oracle EBS
• Peoplesoft
• Dbase
• Alice
• Lotus 1-2-3
• SAS
• SPSS
• XML
• Dynamo
• SQL
• Javascript. UML
• JSP
• Servlets
• Oracle Designer
• Oracle Developer
• Oracle ADF
• ERD tools
• Rational Rose
• ODI
• ERWin
• Informatica
• ODI
• Cognos and Toad. Fusion Middleware (SOA)
• SQL SERVER.

PROFESSIONAL EXPERIENCE:

Confidential

Senior MySQL DBA

Responsibilities:

• Responsibilities: Ensure stability and performance of current systems, and design of future-state systems and processes, including live-live database systems across multiple data centers.
• Tuned reports from taking hours to a few seconds execution time.
• Recovered replication failures, found root cause, and resolved them. No further replication failures for the last six months.
• Completed build out of replication slaves to make all databases HA.
• Identified bottlenecks in application code for developers to fix.
• 7x24 monitoring of All Production and Development Environments
• Defined Temporary Dev database environments on a project-by-project basis.
• Clone of production VM with its database and data set.
• Additional storage to support my testing.
• Resources released after solution soaked in Prod for a few weeks.
• R&D for HA clusters across multiple data centers.
• Master/Master MySQL replication
• Creating and monitoring standby databases to ensure high availability
• Replication and clustering on MySQL
• Install and patching of DBMS software, upgrades and related products in oth production and development or test on various platforms.
• Used jquery, JavaScript, CSS and managed java powered applications
• Used Apache, Redmine and SVN
• Manage Tomcat 7 and 8 servers.
• Configured JBOSS, Jenkins, Apache and Redmine
• Used Amazon Web Service
• Backup and recovery on MySQL server
• Solo DBA resource, command line access with root privileges.
• Remote engagement: Coordinated work between my home office and the India development offices.
• Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
• Identify and make recommendations per database performance issues
• Managing MySQL Databases on Windows, Linux & UNIX
• Upgrade of applications on client’s sites and in-house.
• Setting up new environments for developers based on a new upgrade or service pack on windows and Solaris
• In charge of coordinating developers in customizing software to suit client needs.
• Documenting and updating all necessary procedures and training documents.

Confidential

Senior Database Administrator - MySQL/Oracle

Responsibilities:

• MySQL DBA for a financial document authoring, publishing, and readership tracking system.
• Responsibilities: Ensure stability and performance of current systems, and design of future-state systems and processes, including live-live database systems across multiple data centers.
• Tuned reports from taking hours to a few seconds execution time.
• Recovered replication failures, found root cause, and resolved them. No further replication failures for the last six months.
• Completed build out of replication slaves to make all databases HA.
• Identified bottlenecks in application code for developers to fix.
• 7x24 monitoring of 14 databases instances, hosting hundreds of databases.
• Defined Temporary Dev database environments on a project-by-project basis.
• Clone of production VM with its database and data set.
• Additional storage to support my testing.
• Resources released after solution soaked in Prod for a few weeks.
• R&D for HA clusters across multiple data centers.
• Master/Master MYSQL replication
• Creating and monitoring standby databases to ensure high availability
• Replication and clustering on Mysql; Dataguard and logMiner on Oracle 11g
• Ijnstall and patching of DBMS software, upgrades and related products in oth production and development or test on various platforms.
• Used jquery, JavaScript, CSS and managed java powered applications
• Used Apache, Redmine and SVN
• Manage Tomcat 7 and 8 servers.
• Configured JBOSS, Jenkins, Apache and Redmine
• Used Amazon Web Service
• Backup and recovery on sql, MySQL & SQL Server
• Solo DBA resource, command line access with root privileges.
• Remote engagement: Coordinated work between my home office and the India development offices.
• Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
• Identify and make recommendations per database performance issues
• Managing MySQL Databases on Windows, Linux & UNIX
• Upgrade of applications on client’s sites and in-house.
• Setting up new environments for developers based on a new upgrade or service pack on windows and Solaris
• In charge of coordinating developers in customising software to suit client needs.
• Documenting and updating all necessary procedures and training documents.

Confidential

Database Administrator - Oracle/MySQL

Responsibilities:

• Establishing roadmaps for deploying tools for maintaining optimal IT service.
• Creating and maintaining MYSQL databases
• Managed Oracle & MySQL databases. Performance tuning, backup and recovery, disaster recovery plans and capacity planning .Administered SQL server, MySQL and Java-Derby databases using command line, MyPHP, Mysql Workbench. Used ERWIN, Oracle database designer, oracle Warehouse Builder &Talend
• Managed over 70 databases for hosted clients
• Used PL/SQL codes and packages ; shell scripting
• Worked with SA to consolidate hardware into VMWare & VSphere; migrating data and consolidating databases into VM cloned servers
• Implementation of Paris Applications on client sites which runs against an sql database
• Installing sql server 2008
• Configuring windows 2003/2008, adding windows components Microsoft IIS server *(webserver) and also installing Microsoft .NET framework v3.5.1
• Implementation of Paris applications by configuring an IIS server, database server and an application server.
• Implementation of ccm/ais applications which has a backend oracle database.
• Installation of oracle database software (11g 12C) on both linux and window servers
• Upgrading of oracle databases from 10g up to 12c
• Patching of oracle databases
• Creating new VMs based on internal environment requests.
• Backup and restore of oracle databases
• Cloning oracle databases
• Upgraded MSSQL 2008R2 database to MSSQL 2012
• Install the MySQL server and client software applications
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Perform backup and recovery for MySQL 9i, 10G, 11G databases using RMAN
• Provide performance tuning, maintaining and troubleshoot database problems.
• Create different table spaces, tables, schemas and users accounts.
• Perform daily database administration on production environments.
• Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
• Ensure daily RMAN and export backups are completed and valid for restore and recovery
• Provide administrative database security role by protecting the database, creating and managing users.
• Provide system management role by troubleshooting, reviewing and monitoring database performance.
• Performs general DBA duties (install software, create databases, table spaces, add redo log files, managing storage & work closely with Sr. DBA on capacity planning and performance tuning
• Performs daily database backup of development and test environments, use production data to refresh development and test schemas for testing
• Identify and make recommendations per database performance issues
• Managing MySQL Databases on Windows, Linux & UNIX
• Upgrade of applications on client’s sites and in-house.
• Setting up new environments for developers based on a new upgrade or service pack on windows and Solaris
• In charge of coordinating developers in customising software to suit client needs.
• Documenting and updating all necessary procedures and training documents.
• Trouble shooting and replicating problems in order to fix problems within a short time
• Improving the operational management within the department to ensure top Quality service is provided in order to maintain a positive customer/client relationship.
• Coordinating the team and assigning each engineer with different tasks according to the project plan in order to meet the deadline
• Gathering business and client’s requirements and converting requirements to end products for clients.
• Owning projects from start to finish by coordinating all any necessary competences required

Confidential

Database Administrator

Responsibilities:

• Managed Oracle & MySQL databases. Performance tuning, backup and recovery, disaster recovery plans and capacity planning. Administered SQL Server, MySQL and Java-Derby databases using commandline, MyPHP, MySQL Workbench. Used ERWIN, Oracle Database Designer, Oracle Warehouse Builder & TALEND
• Builds and deployment of applications on Windows, Linux, AIX, Solaris and UNIX
• Performance tuning of oracle databases on Linux, AIX, Solaris and UNIX
• Managing MySQL Databases
• Monitored system performance to ensure that user’s experience is hitch free
• Carried out performance tuning and system debugging
• Building Dell Optiplex 520, Gx 280,270,60, Latitude D505 and D510 by using RIS image
• Set up and configure AVAYA 6220/6408D+ IP Telephones
• Full Administrator use of Active Directory Management, setting up User Groups, Global Groups, Local Groups, user password resets, printer groups and the re-permission of folders.
• Configure, upgrade & install applications like: MS Office 2003, PGP and APTOS, VNC Viewer
• Using Touch Paper (call login system) resolving user problems and handling 2nd line queries
• Networking (TCP/IP, DHCP, DNS)
• Add or modify the network printers
• Restoring user’s lost data using veritas
• Changing backup tapes on the servers