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