Efuet Asaah
Oklahoma City,OK
Summary
Systematic Database Developer with 6 years of experience in designing, engineering architecture and data modeling. Proven track record managing all phases of software development lifecycle (SDLC). Analytical thinker quickly and effectively identifies and resolves technical problems. Driven Database Architect with 5 years of experience in full lifecycle development. Goal-oriented team player succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities. Driven Database Developer with [Number] years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments. Efficient administrator eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup and recovery with good understanding of automation and containerization tools. Team-oriented with stong work ethic. High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
3
3
years of professional experience
Work History
Database Administrator
Mathis Brothers
Oklahoma City, OK
10.2022 - 02.2024
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
- Built databases and table structures for web applications.
- Modified databases to meet needs and goals determined during planning process.
- Developed and updated databases to handle customer data.
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Created and implemented database designs and data models.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Implemented security measures to protect vital business data.
- Coordinated with project management on database development timelines.
- Tested programs and databases to identify issues and make necessary modifications.
- Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks.
- Implemented comprehensive data retention policies that met regulatory requirements while minimizing storage costs.
- Developed scripts and processes for data integration and maintenance.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
Database Manager
Mathis Brothers
Oklahoma City, OK
03.2021 - 10.2022
- Spearheaded the development of custom reports based on complex data sets, delivering key insights to inform strategic decision-making processes at various levels within the organization.
- Boosted end-user satisfaction significantly by responding promptly to customer feedback, making improvements based on their insights and requirements.
- Ensured data integrity and accuracy by conducting regular audits and implementing validation checks.
- Supported application developers during integration efforts by providing guidance on optimal schema designs and query optimizations that improve overall system performance significantly.
- Maintained trusted vendor relationships in support of quality data initiatives.
- Established standardized procedures for data entry, enhancing consistency across all records within the organization''s databases.
- Developed and updated databases to handle customer data.
- Modified databases to meet needs and goals determined during planning process.
- Created and updated database designs and data models.
- Analyzed content access, retention and evaluation projects to maintain nonstop information repository.
- Lent qualitative analytical support to lead data analysis testing policy.
- Designed and developed analytical data structures.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Conducted tests to identify issues and make necessary modifications.
- Set up and controlled user access levels across databases to protect important data.
- Deployed optimal reporting software and developed dashboards and reporting systems for data summaries.
Education
Associate of Science - Database Administration
OCCC, COMPTIA, MICROSOLFT.
Oklahoma City, OKSkills
- Database Management
- Backup and recovery
- Database monitoring
- Database Troubleshooting
- Database Administration
- Relational Database Management
- Data Migration
- Linux Operating System
- Query Optimization
- Database Design
- Running backups
- Performance Tuning
- Stored Procedures
- System Testing
- Database Development
- Process Automation
- Code debugging
- SQL Proficiency
- Customer Needs Assessment
- Systems administration
- Data Security
- Data Modeling
- Cloud Database Services
- Presentations
- Data audits
- Microsoft NET framework
- Patch management
- Cross-platform skills
- SAP PowerBuilder
- Capacity Planning
- Python
- Data Acquisitions
- Information Protection
- Information modeling
coding
I developed a normalized database schema with optimized table relationships, indexing, and query optimization techniques to ensure fast data retrieval and minimal data redundancy.
I chose to use a separate table for order items to avoid data duplication and improve query performance, as it allowed for efficient joining and aggregation of data.
Database design and schema development
- Data modeling and normalization
- Query optimization and performance tuning
- Scalable database architecture.
Timeline
Database Administrator
Mathis Brothers
10.2022 - 02.2024
Database Manager
Mathis Brothers
03.2021 - 10.2022
Associate of Science - Database Administration
OCCC, COMPTIA, MICROSOLFT.