SUMMARY

• D Confidential base Administrator with 4+ years of core IT experience in D Confidential base Installation, Designing, Administration and Troubleshooting d Confidential base servers like MySQL 5.7,5.6, MySQL 5.5 MySQL 5.1, MS SQL 2012, on Windows, Linux, Solaris and Unix platforms.
• Experience of D Confidential base Administration, design, development, maintenance and production support of relational d Confidential bases, business applications, new server setup, MySQL Server installation, upgrade, migration.
• Proficient in using all amazon web services like EC2, EBS, IAM, S3, ELB, RDS, VPC, Route 53, Cloud Watch, Cloud Formation etc.
• Experience in Log Insight and Cloud watch services to diagnose problems and configuring alerts.
• Comprehensive knowledge in D Confidential base architecture and Implementation, D Confidential Modeling, D Confidential base Designing, Tuning D Confidential bases and Queries, Procedures, Functions, Triggers and Events.
• Implemented scheduled downtime for non - prod servers for optimizing AWS pricing.
• Has successfully managed high availability of production systems for Corporate Sectors and Individual Organizations as MySQL DBA.
• Strong MySQL and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Expertise with Shell Script, PHP backend, C# application integrations & development.
• Experience in the administration of Web based Internet/Intranet Client/Server multi-tire distributed application, major in d Confidential base technologies in Consulting, Sales & Finance, Telecom, Quality & Standards domains.
• 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 D Confidential base Consistency Checks using different Utilities.
• Expertise in snapshot, import/export, d Confidential base optimization with the halp of explain plan.
• Expertise in d Confidential base migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.
• Strong experience in D Confidential modeling and their different tools like Oracle Designer, Power Designer, Erwin, MS Visio and DDT.
• Expert of Object oriented programming in order to write robust and re-usable code.
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of D Confidential base as well as frontend. With different project development model like SDLC, Agile, SCRUM etc.
• Expert of writing shell scripting, Perl script for Linux/Unix.
• Developing and maintaining of common objects such as Tables, Views, Indexes, Cursor, Procedures, Functions, Triggers (Autonomous Transaction). Creation of events for scheduling jobs in MySQL.
• TEMPEffective management skills and ability to focus on intermediate as well as long term project goals; excellent organizational skills and believe in TEAM (Together Everyone Achieve More)-Work.
• Involved in client Production Support and Maintenance - Tasks including programming, debugging and testing of existing applications that run in a production environment for purposes of remediation system errors or to extend application life span.
• Experienced with Requirements gathering, d Confidential modeling, System Architecture, Feasibility studies, Scope Documents & requests for proposal (RFP).
• Good analytical, problem-solving skills, verbal and written communication skills.
• Involved in designing, developing, testing and rolling out of complex enterprise applications to completion in terms of D Confidential base as well as frontend. With different project development model like SDLC, Agile, SCRUM etc

TECHNICAL SKILLS:

D Confidential bases: MySQL 5.7/ 5.6/5.5/5.1, MySQL Cluster 7.2 CGE, Mongo dB, NoSQL, Postgresql

D Confidential base Tools: MySQL Workbench, MySQL Toad, MySQL Migration Toolkit, MySQL GUI Tools- MySQL Query Browser and MySQL Administrator, JasperETL, Pentaho d Confidential integrator for ETL Purpose, ManYog, Percona Xtrabackup, Percona toolkit, MySQL Enterprise Monitor, Microsoft Visual studio.NET, Tungsten Replicator, MySQL Fabric

Cloud Platform: AWS, Azure

Other Tools: Ubuntu, VMware, Biz Manager, Microsoft Visual studio.NET, Cloud Watch

ETL Tools: Pentaho, SAP BI

Languages: Shell Scripting, PHP

PROFESSIONAL EXPERIENCE:

Confidential

MySQL DBA

Responsibilities:

• Administration and management of the entire development, QA and production environment.
• Experience with the meta d Confidential tables in INFORMATION SCHEMA.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.7, 5.6 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Worked on Cloud automation using AWS Cloud Formation templates.
• Hands on experience collecting d Confidential on EC2 instances including: CPU utilization, disk read and write operations, and number of bytes received and sent over the network using Cloud Watch monitoring.
• Experienced in setting up Cloud Watch events like Amazon EC2 instance state-change events, Auto Scaling lifecycle events, and instance launch and terminate notifications, Scheduled events, AWS API call and console sign-in events reported by AWS Cloud Trail.
• Performed installation, new d Confidential bases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and d Confidential integrity.
• Increased d Confidential base performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Worked with the engineering team to implement new design systems of d Confidential bases used by the company.
• TEMPEffectively configured MySQL Replication.
• Designed d Confidential bases for referential integrity and involved in logical design plan.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Proficiency in Unix/Linux shell commands.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Configuring/Installing/Troubleshooting PHP.
• Created d Confidential extracts as part of d Confidential analysis and exchanged with internal staff.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Supporting management with different d Confidential base related decisions. Handling Release management and user acceptance.

Environment: MySQL5.7, 5.6, PHP MyAdmin, PHP 4.x, 5.x, NDB Cluster, Percona Xtrabackup, Web Services, Shell Script, Apache, LINUX.

Confidential

MySQL DBA/ Developer

Responsibilities:

• Developed and maintained Development, Test and Production MySQL D Confidential bases on Linux/Unix/Windows(LUW) platforms.
• Built and maintained High transactional (OLTP) and multi-dimensional D Confidential Warehouses (OLAP)
• Created D Confidential base Objects like Schemas, Tables, Views, Stored Procedures, Indexes (cluster/Non-cluster), Triggers, Buffer Pools, User Roles, User Defined Types (UDT) and functions.
• Maintained d Confidential base security by Granting/Revoking users/role (v. 5.5) authorizations and privileges
• Maintained d Confidential base concurrency by setting proper Locks for queries, solved table locking issues, concurrent inserts and external locking issues.
• Experience with MySQL GUI tools MySQL Workbench, MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
• Implemented d Confidential base backups - Logical/Physical, Online/Offline, Full/Incremental and Snapshot backups (MySQL dump backup).
• Recovered d Confidential base using crash, version and roll-forward recovery methods.
• Experience in setting-up of MySQL Replication (master-slave and master-master)
• Experience in setting up and maintaining disaster recovery of MySQL d Confidential bases with High Availability Clustering with Distributed Replicated Block Device (DRBD) with Linux Heartbeat.
• Experience with MySQL cluster Partitioning and sharding feature for large D Confidential warehouse project which includes log-shipping and d Confidential base mirroring.
• Worked on Log maintenance (error logs, query log, binary log, slow query log and relay log)
• Implemented Column Level Encryption and Decryption on some highly secure financial tables.
• Implemented MySQL Enterprise Monitor, MySQL Replication Monitor and MySQL Query Analyser for improving query performance and capacity planning in D Confidential Warehouse d Confidential bases.
• Implemented Innotop and SQLyog monitoring tool on Dev, QA and Prod servers.
• Performed SQL Tuning using EXPLAIN, tuning D Confidential base Configuration parameters for optimal d Confidential base performance.
• Implemented role concept for all users across all MySQL D Confidential base servers and audited them.
• Wrote shell scripts, Perl scripts and setting up CRON jobs to take backup, disk space monitoring, me/O contention, log growth and rate of d Confidential base growth.
• Implemented new features in MySQL Version 5.5 like Triggers, Innodb performance schema, Stored Procedures, etc.
• Monitored speed of expression and functions using BENCKMARK tool.
• Experience with MySQL utility programs: MySQLbinlog, MySQLhotcopy, MySQLaccess, MySQLdumpslow, MySQLmanager etc.
• Maintaining and troubleshooting health parameters of the d Confidential base such as Deadlocks, concurrent inserts, external locking, Buffer Pool, query cache, d Confidential base/application heaps.
• Monitoring log space, d Confidential base growth, Error Log, Disk me/O, CPU utilization on a regular basis.
• Establish standards and procedures to implement d Confidential base security and auditing procedures
• Involved in MySQL migration upgrade (v.4.X to v.5.X) and applying latest fixpaks.
• Created Logical and Physical d Confidential models using ERWIN (D Confidential modelling tool).
• Opened Service tickets to get the resolution from Sun/Oracle for critical d Confidential base issues.

Environment: MySQL 5.1.6, PHP MyAdmin, PHP 4.x, 5.x, NDB Cluster, Web Services, Shell Script, Apache, LINUX.

Confidential

MySQL DBA/Developer

Responsibilities:

• Maintained, monitored, tuned, and support existing MySQL 5.1/5.5/5.6 d Confidential base environments for production, staging, QA and development.
• Automate various DBA tasks using shell scripts.
• Installed and configured MySQL d Confidential bases using binaries, source and RPM.
• Optimization of d Confidential base performance.
• Served as an escalation point for any defined d Confidential base issues regarding performance, security, and ongoing maintenance.
• Worked with the OS and development team to optimize queries and performance functionalities.
• Analyzed problems and incidents, identify root cause for critical incidents and identify, resolve or provide workarounds to addressed issues resulting from new MySQL installations and upgrades.
• Troubleshoot any problems that may come up with the d Confidential base environments.
• Set up infrastructure using custom scripts, Percona Toolkit to monitor d Confidential base availability, locking issues, slave latency, and performance.
• Assisted in formalizing and updating d Confidential base policies, procedures, and technical standards.
• Performed application patches, upgrades, service packs and other maintenance.
• Managed d Confidential base security, disaster recovery, and capacity planning.
• Performed ongoing OS performance tuning, hardware upgrades, and resource optimization as required.