Mysql Security Consultant Resume
Alexandria, VA
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.
TECHNICAL SKILLS
Microsoft Office: XP, 2003, 2007, 2010, 2013
Microsoft Windows: XP, Vista, 7, 10, Linux(Red Hat, CentOS), 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)
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
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.
PROFESSIONAL EXPERIENCE:
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
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
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
- Configured, administered and managed Oracle 11g and MySQL databases.
- Experience installing and configuring Oracle ASM.
- Installed Oracle Data Guard