SUMMARY

Over Six years of IT experience in MYSQL Database Administration, System Analysis, Design, Support of MYSQL Server in the Production Environment, provide QA, Reporting Services , and as been part of Development and Production team, Administers MYSQL running on different platforms in AIX, HP-UX, Solaris, Redhat Linux , Windows X, set up Replication , Cluster Server Environments and Information System Audit risk assessment, Application Security, Internal Control Assessment and ERP Audit

WORK EXPERIENCE

Confidential

MYSQL DATABASE ADMINISTRATOR

• Install, upgrade, optimize, troubleshoot, perform root cause analysis on the Database, I maintain MYSQL 5.6 server and also from between 3.2 to 5.6 versions and distributions from MYSQL Enterprise releases on Linux and windows using related tools like Enterprise Dashboard etc.
• Extensive experience in MySQL Server Installation, Configuration and upgrading, Performance Tuning, Query Optimization and Supported backend SQL and Databases PHP, MYSQL applications on Linux
• Good Knowledge of MYSQL Server Clustering, Replication, and Conduct a walk through of database design including the entire architecture, physical logical schema, selection of storage engines innoDB, MyISAM , NDBCLUSTER , coding of stored procedures triggers prior to deploying solution.
• Expertise in planning and implementing MySQL Server security, database permissions, Backup/Recovery, Client/Server Connectivity and running Database Consistency Checks.
• Expert in MYSQL Server, PL/SQL, SQL Stored Procedures, Cursors, Views, Triggers and Indexes and have in-depth experience in creating Jobs Alerts, SQL Mail Agent, and automating Packages.
• Troubleshoot, resolve, provide root cause analysis and document solutions to complex problems. Design and create databases, schemas, tablespaces, tables, stored procedures, triggers and more, by using DML, DDL, DRL, TCL and DCL SQL syntaxes on MySQL DBMS
• Experience in Database Backup, developed backup and recovery scripts using UNIX shell, performed database Tuning - Set initialization parameters, optimized file I/O, and tuned the physical model by optimizing and reorganizing the schema.
• Demonstrate expertise in utilizing load data in file tool, MYSQLdump, MYSQLhotcopy, MYSQLimport for data migration , Data Transformation Services DTS , and Data Stage in RDBM systems in MYSQL Servers.
• Worked on all phases of database development lifecycle, from gathering requirements to testing, implementation, and support.
• Administered web applications on different platforms using IIS/ Apache / Tomcat web servers,
• Experience with Data Deployment and Development for web transaction and client-server
• transactions. Experience in working with Windows Server 2003 Enterprise Edition, Windows 2008 Advanced
• Server, Window NT and Linux.
• Developed a system to dynamically place marker icons on a map, with each linking to more information on the projects and also interacted with project team leaders to ensure the overall application design is optimal.
• Supported developers with query performance by using optimizer hints and indexes and also designed the logical model and implemented the physical model optimized for Data Modeling decision support
• Developed template for collection of metadata to streamline and optimize the process for data loading and Monitoring Alert logs for any errors, problems or processes running

Confidential

MYSQL DBA

• Experience in Data Migration Management and implementing MY SQL Server security in Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning privileges to users.
• Suggest query optimizations and rewrites as well as server optimizations to improve performance
• Recommend, implement, setup monitoring for troubleshooting replication including master-slave, master-master, MMM, and RHCS Clustering.
• MYSQL SME on team: Served as escalation point for lower level technicians, especially with regard to MYSQL issues.
• General Linux system administration tasks including configuration, troubleshooting of services such as Apache, Postfix, mail etc.
• Performed troubleshooting and configuration of Linux, FreeBSD and Windows servers and services including database services.
• Performed troubleshooting and repaired hardware problems with servers in the data center
• Answer escalated customer calls and communicates through ticketing system and participates in an on call emergency phone rotation.

Confidential

MYSQL DBA

• Install, configure and administer both development and production DB with MySQL 5.x and oracle 9i and troubleshoot and resolve database problems occurring in production environments.
• Create and interpret appropriate database benchmarks to quantify performance bottlenecks and propose solutions to enhance and optimize the overall scalability of the system and backup and recovery, cloud backup with Amazon S3.
• Establish the data management framework that improves the data quality and standards for both database structures and repository and migrate database from SQL Server to MySQL 5.1.
• Performance monitoring/tuning on MySQL and LINUX , Replication set up and configuration processes and Troubleshooting issues.
• MYSQL database Installation, performance tuning, backup and recovery and replication Serve as an expert resource for data modeling, scripting and writing stored procedures.
• Investigate and learn new database technologies e.g., advanced queuing, multi-mastered replication, load balancers, etc. as needed to implement new features and Provide 24 7 on call support on a rotational basis.

Confidential

IT AUDITOR

• Have in depth experience performing audit with IT general controls such as access control, change management, IT operations, disaster recovery and platform reviews Windows and UNIX OS .
• Evaluate segregation of duties over application security involving the company's ERP systems SAP, PeopleSoft, and Oracle Financials and execute audit strategy.
• Knowledge of Control Objectives for information and related Technology COBIT framework developed by the information Systems Audit Control Association ISACA and COSO
• Provides IT risk assessments and SAS 70 /SSAE16 and has conducted review of data centers, extranets, telecommunications and intranets to access controls and ensure availability, accuracy and security under all conditions.
• Communicates with the company's external auditors on general computer control related matters and SOX test procedures
• Reviewed internal policies and procedures and existing laws, rules and regulations to determine applicable compliance and the adequacy of underlying internal controls.
• Identified risks associated with IT infrastructure, operations and applications including pre/post implementation audit reviews for ongoing IT projects along with current legacy applications.
• Liaised between in-house managers/IT department and External Financial and Operational Auditors.
• Prepared audit scopes, reported findings and presented recommendations for improving data integrity and operations
• Evaluated IT and business processes for effectiveness and efficiency, through obtaining an understanding of and documenting key business processes and internal controls.
• Performed IT general controls such as access control, change management, IT operations, disaster recovery and platform reviews Window and UNIX OS .
• Lead integrated audits for evaluating network related issues, identifies IT related risks assessments and updated various risk and controls files to ensure that firm wide identified risks were adequately addressed by control activities.

TECHNICAL SKILLS

• Programming: CSS, HTML, Java Script, PHP, PL/SQL, Python, JSON, AJAX, XML
• APPLICATIONS: All MS Office i.e. Microsoft Excel, Word, Power Point and WordPerfect , MYSQL SERVER 5.6, MYSQL Work Bench 6.1 CE, Oracle Database 11g , SQL Server, Oracle Application Express, Photoshop, SQL Developer , DB Visualizer, Oracle SQL Developer, Putty, PL/SQL, JDeveloper, Command-line tools
• Operating Systems: Windows 2008 Server, UNIX/Linux, Hewlett-Packard HP , VM Ware, Vista, WinXp.
• Databases: MS SQL Server and MySQL Databases
• Languages: T-SQL, C, and C
• SQL Server Tools: Management Studio, Business Intelligence Development Studio, Visual Studio 2008, OSQL, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Wizard, Microsoft Clustering Services MSCS
• Report Tools: MS Reporting Services, SAS
• Data Migration: MSDTS, SSIS, BCP, Data Migration,