MYSQL DATABASE ADMINISTRATOR

SUMMARY

Over Six years of IT experience in MYSQL Database Administration, System Analysis, Design, Development Support of MS SQL Servers 2005, 2000 and 7.0 in Production, QA, Reporting Services, Development environments Replication , Cluster Server Environments and Information System Audit risk assessment, Application Security, Internal Control Assessment and ERP Audit

WORK EXPERIENCE

Confidential

• 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 Redhat linux, and related tools like Enterprise Dashboard etc.
• Extensive experience in MySQL Server Installation, Configuration and upgrading, Performance Tuning, Query Optimization. .
• Good Knowledge of MYSQL Server Clustering, Replication, Data Mirroring, Linked
• Servers, Log Shipping and experience with MySQL Analysis Services for Data Warehousing.
• 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 DTS/SSIS Packages.
• Experts in extracting data from different databases like MYSQL Server, SQL Server 2000/2005/2008, oracle 9i/ 10g, MS Access, Excel and integrating them to different platforms like Cold environment, Fusion, ASP.net, JSP to generate reports using SSRS and Crystal Report.
• 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 including SQL Server Integration Services SSIS , 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.
• Good Knowledge of MYSQL and SQL Server Clustering, Replication, Data Mirroring, Linked
• Servers, Log Shipping and experience with MS SQL 2005/2008 Analysis Services SSAS for Data
• Warehousing.
• Experience in working with Windows Server 2003 Enterprise Edition, Windows 2000 Advanced
• Server, Windows 2000 Server, Window NT and UNIX.
• 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 PL/SQL stored functions, 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.

Confidential

• Experience in Data Migration Management and implementing MY SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Suggest query optimizations and rewrites as well as server optimizations to improve performance
• Recommend, implement, setup monitoring for, and troubleshoot 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

• 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 ORACLE 9i 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

• 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,