Resume

Sign in

MySQL Database administrator

Location:
White Plains, New York, United States
Posted:
November 09, 2018

Contact this candidate

Resume:

Immanuel Johnraj

Senior Database Administrator

Email : ac7ndt@r.postjobfree.com

Phone : +1-914-***-****

Citizenship : US Permanent Resident

Summary:

Over 11 years of experience in MySQL Database Administration (DBA) in Linux and Solaris environment

Installation and configuration of MySQL server and creation of databases

Moving the production Database to AWS RDS Aurora and Oracle Cloud and maintenance

Conversant with all phases of Software Development Life Cycle involving System Analysis, Design, Development, Testing and Implementation

Expertise in installation, configuration, Backup & Recovery, application support, Resource Management, User & Security Management

Responsible for ensuring high availability and performance of the databases that supports the system

Excellent skills in Database administration activities like Backup & Recovery, Database Security, Database designing and Query optimization

Experience in Installation, Configuration and Administration of MySQL 4.x/5.x server on Linux Red-hat AS 3.x/4.x/5.x in small and large environments

Excellent Experience in migration Of MySQL Server 3.x to 4.x and 4.x to 5.x, 32/64 bit in non-cluster environments

Experience in implementing MySQL Cluster 7.x for Production environments

Good at Linux administration and shell & Perl scripting

Successfully implemented Database Monitoring in MySQL Server for high availability

Experience in preventive maintenance, security schemes, performance tuning, query optimization, client/server connectivity, database consistency checks

Experience in working with quality assurance, version controlling tools, in order to manage SQL configuration or scripts changes from development to production as per company’s change management policy

Good knowledge in Nosql techniques and cassandra

Expert in working with ticketing tool like Oracle E Business suite (CRM)

Administration knowledge of PostgreSQL Server

Hands on experience in MySQL tools like MogileFS, Hadoop and Nagios

Worked with different MySQL tools

Implemented and managed successfully various MySQL Replication topologies (Master-Slave, Master-Master)

Sever virtualization through SAN

Experience in providing 24x7 Production support

Experience in large database architecture designing

Creating users and assigning privileges

Experience on huge database backups, restore and schedule backups

Experience in MySQL latest version upgrade

Performance tuning and Query optimization

Experience in server tuning

Experience in maintaining a high traffic websites

Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management

Responsible for improvement and maintenance of the databases to include rollout and upgrades

Worked to ensure that the associated hardware resources allocated to the databases had high resilience and performance tuning

Configure and maintain tools in our operations center that help keep the database operating efficiently

Troubleshooting service problems and escalating issues within the organization as needed

Capacity planning for changes in the size of databases due to business growth

Good interpersonal, analytical and communication skills

Have handled regular coordination between Onsite & offshore on daily basis

Certifications & Training programs:

Oracle Certified Associate for Database Administration in Oracle 9i (OCA)

Juniper Networks Certified Internet Associate

Diploma in Software Testing from Amity Soft Education

Implementation Training program on Information Security Management System (ISMS) as per ISO 27001:2005

Quality Internal Auditor for ISO 9001:2000

Technical Skills:

Databases : MySQL 5.x/4.x/3.x, PostgreSQL 7.x/8.x, Oracle 9i/10g/11g

Scripting : Shell, Perl Scripting

Languages : C, C++

Operating Systems : Red Hat Enterprise Linux 4.x, 5.x,Centos -5.5, Fedora Core, Ubuntu

Hardware : HP DL -380, DL 580, Dell - Power Edge R610

Storage : HP-EVA, DELL EQAULLOGIC P-400.P600

Virtual Machines : OVM, VMWare

Web : HTML, DHTML

Education:

Bachelor of Science ( Bsc ) from Madras Christian college, Tamilnadu, India

Master of Business Administration (MBA) Systems from Madurai Kamaraj University – TamilNadu, India

Application Areas:

Backup

Recovery

Replication

Database Security

Database Monitoring

Performance Tuning

Clustering

Troubleshooting

Designing

Professional Experience:

Client : Engage121 Inc

Location : Norwalk, CT

Role : Senior Database Administrator

Duration : Aug 2012 to Till now

Employer : Engage121 Inc From Aug 2012 to Till now

Engage121 provides the ability to manage the integration of social media into all customer-facing operations. The company offers one-to-one relationship with the customers and influence key business metrics. Engage121 manage client social media with ease, efficiency and creativity.

Installation and configuration of MySQL database servers

Configuring replication for databases and various types of Replication format

Migration and upgrade of MySQL from lower versions 5.0 to 5.5 with minimal downtime

Consolidation of various MySQL databases with proper capacity and load planning

Troubleshooting and resolving MySQL replication, table lock issues, table repair and max connections

Good knowledge of working in high load and high transaction environment

Database and Application Production servers uptime upto 99.9 %

Servers daily monitoring, Maintenance and error fixing

Extensive usage of MySQL engines like innodb, myisam, Archive and Federated

Optimization of myisam and innodb tables

New hardware setup for Production environment

Configuring services for MySQL

Creation of database indexes on certain tables to improve query performance after thoroughly testing the same in the development environment

Restoring and Recovery Management from Tables which are crashed

Taking backups and provide security for databases

Written various Linux shell scripts to monitor the database / server availability, space availablity and load average for both production and development servers

Written and monitored Max connections on the production databases thorugh scripts.

Disaster recovery planning

SSL Validation of all the Secure sites

Solr setup for Apache Lucene new projects

Environment : MySQL 4.x/5.x, Oracle 9i/10G, CentOS 5.x/6.x, Linux Red-hat Enterprise

3.x/4.x /5.x in HP DL G4, G5, Dell Poweredge

Client : Kligerweiss Infosystems

Location : Greenvale, NY

Role : MySQL Database administrator

Duration : Dec 2011 to Jul 2012

Employer : Kligerweiss Infosystems Inc

KWI offers end-to-end managed services solutions for a broad range of clients in specialty retailing and other areas of direct-to-consumer sales. KWI’s small-to-midsize clients receive the same high-end functionality as major retailers, at extremely affordable rates

Recovery of databases, tables of both myisam and innodb

Install NMS agent and monitoring through MySQL Enterprise Management

Automation of various pro-active monitoring scripts including replication delay, lock, slave monitoring and max connection issues

Monitoring System Performance

Handling MySQL tools like Hadoop and MogileFS effectively in production environments

Administering and maintaining the development and test Databases for portals

Expertise in sendmail and designing the mail format

Writing scripts to optimize the monitoring by making concurrent sessions

Replication of MySQL database monitored through scripting

Backups are taken and monitored through scripts

Expertise in Data modelling

Installation and configuration of Apache and PHP

Developing Stored procedures, Triggers, views based on the requirements

Installation and Configuration of Oracle in Linux flavors with the recommended RAID

Creation of Tablespaces, data files, users etc

Creation of oracle roles, granting privileges and profiles etc

Check Alert Log errors and make necessary actions to rectify them

Configuration and Installation of PostgreSQL 7.x and 8.x

Configuring logical backups and Vacuam process in PostgreSQL

Query Tuning and trouble shooting in PostgreSQL servers

Environment : MySQL 4.x/5.x, PostgreSQL 7.x/8.x, Linux Red-hat

3.x/4.x /5.x in HP DL G4, G5

Client : GE Aviation

Location : Cincinnati, OH

Role : Lead Consultant

Duration : Sep 2011 to Dec 2011

Employer : Genpact LLC

GE Aviation is a world-leading provider of commercial and military jet engines and components as well as avionics, electric power, and mechanical systems for aircraft with an extensive global service network to support these products.

Responsibilities:

Migration and upgrade of MySQL from lower versions 4.x to 5.1 with minimal downtime

Consolidation of various MySQL databases with proper capacity and load planning

Troubleshooting and resolving MySQL replication, table lock issues, table repair and max connections

Extensive usage of MySQL engines like innodb, myisam, Archive and Federated

Optimization of myisam and innodb tables

Expertise in writing stored procedures, triggers and views

Maintained database ranging from 20 GB to 1 TB

Configuring remote database support

Expertise in migrating MySQL Database from Solaris to Linux and Windows to Linux

Creation of database indexes on certain tables to improve query performance after thoroughly testing the same in the development environment

Restoring and Recovery Management from Tables which are crashed

Taking backups and provide security for databases

Good Networking skills

Expertise in Database Normalization

Recovery of databases, tables of both myisam and innodb

Install NMS agent and monitoring through MySQL Enterprise Management

Automation of various pro-active monitoring scripts including replication delay, lock, slave monitoring and max connection issues

Written various Linux shell scripts to monitor the database / server availability, space availablity and load average for both production and development servers

Configuring replication for databases and various types of Replication format

Written and monitored Max connections on the production databases thorugh scripts.

Writing scripts to optimize the monitoring by making concurrent sessions

Replication of MySQL database monitored through scripting

Backups are taken and monitored through scripts

Expertise in Database Normalization

Configuration and Installation of PostgreSQL 7.x and 8.x

Configuring logical backups and Vacuam process in PostgreSQL

Installation and Configuration of Oracle in Linux flavors with the recommended RAID

Creation of Tablespaces, data files, users etc

Creation of oracle roles, granting privileges and profiles etc

Check Alert Log errors and make necessary actions to rectify them

Environment : MySQL 4.x/5.x, PostgreSQL 7.x/8.x, Oracle 9i/10G,Linux Red-hat AS

3.x/4.x /5.x in HP DL G4, G5

Client : Sify Technologies Ltd

Location : Chennai, India

Role : Database administrator

Duration : Oct 2005 to Apr 2011

Employer : Sify Technologies Ltd.

Sify Technologies Ltd is pioneers in providing multi-city carrier –neutral Data Center Hosting with 5 Tier-3 and 6 Tier-2 Data Centers. The company is focused on Internet Protocol based data services over a Tier 1 telecome backbone Infrastructure in India.

Responsibilities:

Involved in database design and support.

Implemented scheduled backups using Shell script.

Restoring and Recovery Management when tables crashed.

Worked on Table maintenance operation like mysqlcheck, myisamcheck, Repair, Optimize, Analyze, check…etc.

Support to Development team while writing Queries and DB related issues.

Worked with different MySQL tools.

Upgraded the MySQL old version to MySQL new version.

Tuning the database to support 10K concurrent users for online exam

Supporting the testing group in running automated bridging applications

Database maintenance plan creation and troubleshooting.

Verify backups and error logs on the servers and troubleshoot on any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

Implemented DRBD as high availability solution using Mysql.

Database triggers and stored procedures were developed and implemented to perform constraint checking and task automation.

Setting up standby server and maintaining it.

Analyzing and resizing objects for Production Database

Installation and Configuration of Oracle in Linux flavors with the recommended RAID

Creation of Tablespaces, data files, users etc

Creation of oracle roles, granting privileges and profiles etc

Check Alert Log errors and make necessary actions to rectify them

Documentation of activities

Environment : 5.x, Linux Red-hat AS 5.x in HP DL G6



Contact this candidate