Experience as DBA in managing Oracle DB, MY SQL and SQL Server DB
engines.
Hands on experience in Oracle DB/Oracle EBS R12, MYSQL and MS SQL
database is mandatory.
Knowledge or experience working in Oracle Database and Oracle EBS
R12, MySQL will be an added advantage.
Have knowledge on Oracle Cloude, AWS Cloud, AWS EC2, AWS RDS and
DB technologies
Willingness to learn about technologies related to database and backup
infrastructure, such as storage, backup, operating system and
automation tools, cloud solutions or other database technologies.
Demonstrated ability to effectively establish and maintain cooperative
working relationships within a global, diverse, multicultural
environment.
Bachelor's Degree on Computer science or Information technology
streams
Willing to work in Marilao Bulacan
Job Responsibilities
Read & analyses log/error log for Databases
Alerts configuration, monitoring alerts and fine-tuning thresholds
Backup/restore (Oracle DB, Oracle EBS Application, My SQL , SQL
Server) specific data
Installing/deploying databases, configuring backups, maintenance jobs
and other features as needed to support database capacity,
performance or product functionality requirements.
Performing database administration tasks, including at latest versions
of databases.
Performing data restores, patch set / service pack installation and
deinstallation, edition upgrade and downgrade, troubleshoot locking,
corruption issues as well as suggest and implement solutions with
minimal downtime
Perform operational duties including database backups, application
server health, service recycling.
Identify and resolve operational issues (e.g. batch failures, network
issues, client data feed errors)
Experience in Monitor server performance, memory utilization, CPU,
file systems, databases, batch jobs, backup and restore concept with
best practice.
Extensive experience in Oracle Application and Database, MY SQL, SQL
server high availability solutions- Log shipping, Mirroring, Replication,
Clustering and always ON.
Prepare, review, test, and execute T-SQL and PowerShell scripts to
perform database administrative tasks as assigned.
Investigate performance issues, provide and implement tuning
solutions
Act as part of a corporate team, creating and extending existing
documentation and continuously sharing information and assisting on
tasks with other team members.
Working with monitoring tools
ull job description
Responsibilities:
· Backup and Recovery: Establish backup and recovery strategies to protect
data integrity and ensure business continuity. Test backup procedures
regularly to verify reliability and effectiveness.
· Security and Compliance: Implement security best practices for database
access control, encryption, and auditing. Ensure compliance with regulatory
requirements (e.g., GDPR, HIPAA) and industry standards.
· Performance Optimization: Identify and address performance bottlenecks,
query inefficiencies, and resource contention issues in databases. Optimize
database configurations, indexes, and queries for improved performance.
· Monitoring and Alerting: Set up monitoring tools to track database
performance, health, and availability metrics. Configure alerts to notify
stakeholders of potential issues or anomalies.
· Automation: Develop and maintain scripts, tools, and pipelines to automate
database provisioning, configuration, deployment, and migration processes.
This may involve using tools like Ansible, Chef, Puppet, or custom scripts.
· Continuous Integration (CI): Integrate database changes into the CI/CD
pipeline, ensuring that database schema changes, data migrations, and
other database-related modifications are tested and validated automatically.
· Continuous Deployment (CD): Implement automated deployment processes
for database changes, coordinating with application deployment pipelines to
ensure consistency and reliability across environments.
· Version Control: Manage database schemas, scripts, configurations, and
other artifacts in version control systems (e.g., Git), enabling collaboration,
change tracking, and rollback capabilities.
· Capacity Planning and Scaling: Analyze database usage patterns and
performance trends to anticipate capacity requirements. Scale database
resources (e.g., storage, compute) as needed to support application growth
and user demand.
· Documentation and Knowledge Sharing: Document database
configurations, procedures, and troubleshooting guidelines. Share knowledge
and best practices with team members to facilitate collaboration and skill
development.
