SUMMARY:

• Over eight years experience as Confidential Database Administrator and Database Architect working with MySQL, one year with Oracle Databases on multiply UNIX/Linux and Microsoft Server platforms and MS SQL 2012.
• Over five years experience as Confidential System Engineer working with multiply UNIX/Linux and Microsoft Server platforms, systems/network architecture, installation, implementation, integration, security and administration with Confidential programming background.
• Knowledge of Big Data environment like Hadoop, Hive, Pig Latin and NoSQL Database Cassandra

TECHNICAL SKILLS:

• MySQL, MS SQL 2012, Oracle, Cassandra, MongoDB
• PHP, Python, BUSH Scripting
• Computer system monitoring with Zabbix, Nagios, Cacti
• Experience with Linux systems, like Ubuntu, CentOS 6 - 7.*, Fedora 5.6-19, Red Hat 4.*,5.0), Windows 2003-2012
• Deep knowledge of MySQL, MongoDB,Cassandra, bind (DNS system).
• NodeJS, Ionic
• Databases: MySQL 5.*, MS SQL 2012, Cassandra 2.*, MongoDB
• Operating Systems: Ubuntu, CentOS, Red Hat
• Programming Languages: SQL Query Languages, Javascript, PHP, BASH, Python.
• Knowledge in Hadoop Distributed File System, Pig Latin
• Monitoring/management Nagios, Cacti;
• VNC, SSH, Citrix, MS Terminal;
• KVM, VMWare ESXi, XEN;

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton, FL

Database Engineer

• Normalize RDBMS;
• Participated in the development of new products ;
• Architect and administrate MySQL/MongoDB;
• Developing and supporting production,QA and development MySQL databases;
• Responsible monitoring and optimizing MySQL database performance and capacity planning;
• Creating Data Warehouse with Triggers, Procedures and ETL;
• Importing/Exporting data from and to xml/csv/txt/tsv files with and without ETL;
• Trace the slow running queries and optimize SQL queries for improved performance and availability;
• Managing MySQL servers instances (RDS), disaster recovery and replication;
• Developing and supporting MySQL database replication and clustering, and plan and execute for database scalability;
• Working with application engineers, developers and the QA team as well as applications support teams in the maintenance and care of the Linux Network and MySQL infrastructure;

Confidential, New York, NY 

MySQL Database Administrator/ Database Developer

• Participated in the development of new product ;
• Analyzing current environment & designing workable in-house solutions
• Understand core systems and data processes for normalization, data validation, data aggregation, and customized reporting and migrations to the new product
• Identifying & building tools to assist in database and transactional processing (i.e. Store Procedures, Triggers, etc.)
• Worked on design and development of Relational Database Management System (RDBMS) and reduce the redundancy by data normalization.
• Migrated high-volume fields from MySQL to the Elasticsearch in order to get easy access and high speed users search
• Traces the slow running queries and optimize SQL queries for improved performance and availability
• Managing MySQL servers instances (AWS), disaster recovery and replication
• Creating Data Warehouse with Triggers, Procedures and ETL
• Creating Data Marts through views for different departments

Confidential, New York, NY

MySQL DBA / Database Architect

• Responsible for designing, installation, administration and support of Unix/Linux servers;
• Created new web product from the ground zero with full support after product was launch in the production.
• Server Installation, Master-Master, Master-Slavse Configuration MySQL 5.5
• Performance tuning in MySQL Applications instances and other production DB s
• Patch analysis and schedule downtime for applying of patches for MySQL
• physical Linux serv ers under CentOS 6.5, on HP and Supermicro hardware;
• MySQL 5.5
• Oracle 11g instance
• MS SQL 2012
• Pull of virtual servers under Linux Citrix virtualization (XEN Base) software;
• Various services (postfix, bind, apache, snmp, ntp, ssh, tftp, etc.)
• Developed backup strategy, programmed scripts for it;
• Migration Data from Oracle 11g to MySQL
• Monitored network and servers using Nagios;
• Troubleshoot hardware and software, supported users.
• Learned   Hadoop   Architecture as part of Migration
• Knowledge of NoSQL
• Virtualizing the lab environment using VMWare

Confidential, New York, NY

Unix Systems Administrator/Database Administrator

• Supported Forex Trading system (250 servers x 2 locations). Functioned as  DBA   and Linux Administrator.   Oracle   database on RH 5 servers (16 instances), MySQL 5.1 (3 DBs).
• Configured and Installed Oracle 11g on Red Hat servers (16 instances).
• Regular database backup activity
• Supported MySQL Databases
• Provide 24/7 support for multiple production instances 
• Performance tuning in Oracle Applications instances and other production DBs
• Shell scripting for cron jobs & some customization in already created scripts.
• Installed, configured and maintained over 500 GNU/Linux servers ( Red Hat, CentOS, Fedora ) across three different datacenters; managed installation, patching, monitoring, backups, disaster recovery and business continuity strategies, troubleshooting and resolution, application enhancements, and modifications.
• Conducted configuration and maintenance of all data center systems and servers. HP G5 360, HP Blades c7000, Cisco MDS 9509.
• Monitoring network and servers using Nagios, developed custom plugins for it;
• Responsibility for DNS Servers with writing Confidential security script, which allows programmers and production make they own zones for testing and using zones.
• Provided administration and support for Unix, Linux, and virtualization technologies, including Xen 5.5 and VMware 4.0 ESX
• Configured and administered company websites, including general LAMP stack, Perl/Python/PHP/Java, Apache, Linux, and MySQL.
• Performed troubleshooting, networking, security, services, reporting, monitoring, database-backed management, capacity planning, and strategic planning

Confidential, New York, NY

Unix Administrator

• Performed Unix installation and configure and troubleshoot server OS and hardware issues
• Installed and configured FreeBSD 5.4, 6.1, CentOS 3.6, 4.2, 4.3, 4.4. Windows workstation/ server 2003.
• Maintain and Supported Data Bases MySQL 4.1, Oracle 8g and PostgreSQL 8.9
• Monitored network and servers using Cacti
• Implemented company network security and provided administration of several environments from Enterprise Level LAN/WAN and Production based Networks.
• Responsible for end-user and product-related technical support for Web based Applications, Hardware vs. Operating System Relationships, internal software suites, and logged application errors & end-user feature requests.
• Provided administration, monitoring, backup/recovery, problem determination and resolution (break/fix), and general technical support; configuration and maintenance of all data center systems and servers.
• Implemented data center security through proactive monitoring, maintenance and upgrades of security patches, anti-virus software, etc.
• Coordinate work with remote Network Operations Center, other Technology groups and Operations teams to provide detection and recovery of system outages, problems, and faults.
• Responsible software problem report tickets, daily reports, logs and changes are completed.
• Conducted capacity planning and development of datacenter services and processes, storage and network solutions for secure and reliable management of all systems.

Confidential,  New York, NY

Unix Administrator

• Performed installation and configuration of Red Hat 9.0, Linux Fedora Core 2.0, 3.0, FreeBSD 4.11. Windows workstation/server 2000. Set up departmental software and integration onto network.
• Maintain   data   base   with old/new clients
• Supported MySQL,Postre SQL, DB2
• Monitoring Network with Nagios