Mysql Database Engineer Resume
Baltimore, MD
SUMMARY:
Dynamic IT Professional with over 8 years of experience providing top - level customer service coupled with a strong technical knowledge. High proficiency in the support of systems to drive company growth and technical innovation. Skilled in providing effective leadership in fast-paced environments.
SKILLS:
Strong Analytical Skills, Resourceful in project completion, time management, multi-tasking, excellent written, verbal communication and leadership skills, excellent inter-personal relationship
TECHNOLOGY:
- Microsoft Office(XP, 2003, 2007, 2010, 2013)
- Microsoft Windows XP, Vista, 7, 10, Linux(Red Hat, CentOS)
- Microsoft Windows Small Business Server, SQL Server, Microsoft Exchange Server
- Heat ticketing platform, BMC Remedy
- Dameware Remote Control, Microsoft RDP, VNC Remote Control
- Active Directory, Oracle ERP, Crystal Reports, Rumba Terminal Emulator
- In-depth knowledge of TCP/IP, DNS and Internetworking Technology
- Citrix, SSL VPN, SCCM(computer management, software deployment packages)
TECHNICAL SKILLS:
MySQL Database: MySQL 5.0, 5.1, 5.5 and 5.6. Percona, MySQL Cluster & Replication (Master-Slave, Master-Master Replication), Schema Design and maintenance, MySQL Enterprise Manager, Monyog
Oracle Databases: Oracle 8, 9i, 10g, 11g and 11gR2 RDBMS.
Oracle Tools: Oracle Enterprise Manager(OEM) with Diagnostics, Oracle Universal Installer, Database Configuration Assistant, Database Upgrade Assistant, Oracle Net Manager, Recovery Manager (RMAN), Data Pump, TOAD, Oracle VM Manager, and Command-line tools.
PostgreSQL: 9.4.7, 9.5.4, PgAdmin AWS DynamoDB, AWS Cloudwatch
WORK EXPERIENCE:
Confidential, Baltimore, MD
MySQL Database Engineer
Responsibilities:
- Responsible for standing up a new Database Server in AWS
- Maintain, monitor and manage RDS Instances
- Database Management for new Project(MySQL and PostgreSQL)
- AWS RDS Incorporation
- Assisting Development teams with Database Design
- Coming up with Best Practice Document for Database
- AWS RDS versus EC2 comparison
- ETL Data Management
- Tuning Developer SQL queries to Database
- Using DynamoDB for session store management
Confidential, Alexandria, VA
MySQL Security Consultant
Responsibilities:
- Performed Scan Analysis based on Database Scan
- Drafted and Implement MySQL Database Baseline based on CIS Security Benchmark Recommendations
- POA&M Management, Remediation and Closure
- Advised on Security Best Practices
- Drafted and Implemented Account Management Plan
- Monitoring Database Alerts and taking appropriate actions
Confidential, Hyattsville, MD
Consulting DBA
Responsibilities:
- Manage MySQL and Oracle Databases for clients
- Performed weekly backups and recovery as needed
- Performed tuning on databases to ensure optimization performance of database and servers
- Used MySQL Workbench, Oracle Enterprise Manager and Command Line as monitoring tools
- Maintained user security access to databases including creating new users
Confidential, Columbia MD
IT Systems Administrator
Responsibilities:
- Problem analysis and resolutions
- Oracle ERP account creation and maintenance
- Active Directory(new accounts, account maintenance)
- Microsoft Exchange Server (creating new and maintaining old accounts)
- Mainframe account creation and maintenance
- Remedy, Oracle ERP
- Investigates causes, test solutions, and puts solutions in place to reduce calls to help desk, as well as future handle times
- Support over 1600 end user’s
- Microsoft System Center, Microsoft Configuration Manager
- Local and network printer trouble shooting
- VPN connectivity trouble shooting (Citrix and SSL VPN)
- Windows configuration, Domain Name Configuration
- Software and hardware installation, support and troubleshooting
IT Support Analyst
Confidential
Responsibilities:
- Problem analysis and resolutions
- Completes requests for password resets in Active Directory, Oracle E-Business and
- Student Management System (SMS), Heat, Oracle E Business
- Log all help desk calls and email requests into Problem Reporting System and updates problem profiles in Heat
- Investigates causes, test solutions, and puts solutions in place to reduce calls to help desk, as well as future handle times
- Supported over 1000 end user’s
- Windows 2000, XP, 7 environment
- General help desk telephone support
- Proficient with MS Office and Exchange and Outlook Email applications
- Utilized Dameware remote Control
- Local and network printer trouble shooting
- VPN connectivity trouble shooting
- Member of 2 man team attending to requests via department email box
- Utilizing inventory management system to enter new equipment into inventory
- Windows configuration, Domain Name Configuration
- Software and hardware installation, support and troubleshooting
Confidential, Baltimore MD
MySQL DBA
Responsibilities:
- Managed MySQL databases (over 50 databases in a replication environment)
- Performed backup and recovery of MySQL databases
- Managed logs and errors
- Built Oracle databases for development and testing purposes
- Maintained databases for each environment
- Created database objects
- Altered database structures and schemas as needed
- Allocated storage - creating table spaces, adding and resizing data files to existing table spaces, creating and multiplexing redo log files
- Wrote SQL scripts to create tables, indexes synonyms, views and other objects
- Installed, configured, and maintained all database servers,
- Worked with network and system engineers to configure robust and scalable systems for our clients
- Consulted with and provide guidance to database users and client groups, often recommending tactical and strategic solutions.
- Provided guidance for troubleshooting escalated issues.
- Participated in the development of data/ database architectures and management policies, procedures and standards
Confidential, Baltimore MD
MySQL/Oracle DBA
Responsibilities:
- Installed the Oracle server and client software applications in a medium environment (35 databases)
- Created user accounts and appropriate privileges as well as maintaining database security.
- Performed backup and recovery for Oracle 9i, 10G, 11G databases using RMAN
- Provided performance tuning, maintaining and troubleshoot database problems.
- Created different table spaces, tables, schemas and users accounts.
- Performed daily database administration on production environments.
- Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
- Ensured daily RMAN/MySQLDump and export backups are completed and valid for restore and recovery