JAPHET OGOR
ad2pm4@r.postjobfree.com
PROFILE SUMMARY
Proactive and resourceful professional with substantial experience in database design, maintenance, and troubleshooting. Proven track record of success in designing and optimizing databases to meet the ever-changing needs of the business. Proficient in various programming languages combined with solid understanding of data security and data integrity. Repeatedly successful in navigating complex technical environments, and possess strong, PL/SQL expertise in stored procedures, performance tuning, and optimization. Demonstrated expertise in database security, backup and recovery strategies, and implementing disaster recovery plans. Adept at collaborating with cross-functional teams to understand business requirements and providing scalable database solutions.
CORE COMPETENCIES
Database Design
Database Administration
Performance Tuning
Backup and Recovery
Query Optimization
Data Migration
Replication
Database Monitoring
SQL Profiling
Problem-Solving
Analytical Thinking
Attention to Detail
Communication
Team Collaboration
Troubleshooting
Database Installation
Routine Maintenance Tasks
Database Optimization
KEY QUALIFICATIONS AND SKILLS
Highly skilled in managing deployment and overseeing maintenance of new databases, new schemas and new database objects.
Proficient in contributing to defining application database standards and creating application data models.
Rich experience in managing database performance in the context of applications while working closely with infrastructure and application teams.
Expertise in code optimization and improving database efficiency through Maintenance tasks Re-Indexing, Updating Statistics, Recompiling Stored Procedures.
Skilled at validating and thoroughly testing deduplication of backup data by integrating networker backups with EMC Data Domain.
Accomplished in designing and implementing a configurable Application and data security model to ensure controlled access to the data on production, test and development environments. TECHNICAL SKILLS
Microsoft SQL Server Transact-SQL (T-SQL) SQL Server, Integration Services (SSIS) SQL Server Reporting Services (SSRS) SQL SQL Server Management Studio VMware, Azure, SQL Azure Resource Manager Azure DevOps Services Microsoft Azure
PROFESSIONAL EXPERIENCE
SQL Server Database Administrator Jul 2022 - Present EPIPHANY ACCESSIBLE
Design and maintain databases to meet the needs of the organization.
Monitor and optimize databases to ensure their efficiency and performance.
Perform database backups, recovery, and security tasks.
Manage and maintain SQL Server databases, ensuring optimal performance and reliability.
Implement and monitor backup and recovery strategies to safeguard critical data.
Conduct routine database health checks, identifying and resolving performance bottlenecks.
Design and implement security protocols to protect sensitive data and ensure compliance.
Provide on-call support for critical database issues, minimizing downtime and ensuring data availability.
Troubleshot and resolve database-related issues.
Develop and implement database solutions to meet the business needs.
Design and implement database security measures.
Develop and maintained stored procedures.
Provide technical support for database-related issues.
Administer SQL Server databases on multiple servers and ensure their high availability and performance (SQL Server 2016- 2019) and SQL Server management Studio (SSMS) VMWare.
Migrate databases between different SQL Server versions and instances.
Configure and manage Always on High Availability solutions (AOAG groups) and DR.
Stored Procedure Code Development and Standardization.
Prepare, package, coordinate and implement production release and fixes.
Identify and advise on issues and necessary remediation as appropriate.
Test databases, correct errors and make necessary modifications for optimal performance.
Involved in migration from On-Prem to cloud (Azure).
Optimizing and performance tuning using execution plans; and SQL Profile and Database Tuning advisor.
Design and tests database installation, implementation, and recovery scenarios.
Support SSIS and SSRS projects, Python, JSON.
Determine tests to use and collects appropriate data according to established guidelines. Cloud (Azure/AWS). SQL Database Administrator Jul 2018 - Jun 2022
SALI INVESTMENT & WORLD CARGO
Monitored hardware and software performances and ensured systems and applications are regularly updated.
Implemented changes and apply new patches and versions when required.
Created and maintained appropriate documentation of private data ethically, including PIIs.
Developed high-speed transactional recovery techniques and backup data and also configured DR solutions with transactional replication from distribution server with multiple updatable subscriptions.
SQL Server database administration, configuration, load balancing, performance tuning, backup and recovery.
Utilized correct “high availability” technologies to maintain the greatest possible uptime.
Kept database patches and security measures up to date to keep data safe from accidental or unauthorized damage, modification or disclosure.
Managed, approved, and scheduled all new/existing database installs and upgrades.
Responsible for managing and auditing user access control in compliance with SOX compliance and company policy defining appropriateness of user access.
Made recommendations for code changes to the Development department.
Tracked proposed changes until installed.
Participated in 24x7x365 on call support rotation, as well as evening and weekend maintenance and deployment cycles as needed.
Performed routine performance and availability testing on database servers to ensure scalability, resiliency, and capacity of all applications.
Perform daily monitoring of database servers to include error logs, database file sizes, successful backups, volume space, etc.
Assisted in the architecture of database systems for high volume database applications with high availability requirements.
Designed, created, and maintained stored procedures for various functions and applications. EDUCATION
B.Sc. Pharmacy
B.Sc. Computer Science
REFERENCES
Upon Request