Collaborate with the development team to design and implement efficient database structures that meet the organization's requirements
Develop and maintain database schemas, tables, views, stored procedures, and functions
Monitor and analyze database performance, identifying and resolving bottlenecks or other performance issues
Optimize queries, indexes, data schemas, and database configurations to enhance system performance
Build a proactive service engagement, understanding the database workloads and data model, to evaluate ASH and AWR and other diagnostic tools to ensure a continued stable and performant database
Working with DevOps, implement and maintain database security measures to protect sensitive data from unauthorized access or breaches
Develop and maintain data integration processes, including Extract, Transform, and Load (ETL) workflows
Create and maintain comprehensive documentation for database environments, including data dictionaries, schemas, configurations, and standard operating procedures
Generate regular reports on database performance, capacity, and usage
Working in collaboration with DBA's and DevOps, develop and maintain database backup and recovery strategies to ensure data integrity and availability
Requirements
Bachelor’s degree in computer science, Information Technology, or a related field, or equivalent experience
At least 8 years of experience in Oracle database environments and PostgreSQL
Proficient in database performance tuning, query optimization and capacity planning
Experience in cloud-based database services, such as AWS RDS
Solid understanding of data security, backup, and recovery procedures
Strong understanding of relational database concepts including primary/foreign keys, many-to-many relationships, and complex joins operations
Experience in system analysis and design, problem-solving, support and troubleshooting
Experience with cloud database platforms (e.g., AWS RDS, Azure Cloud) is a plus
Benefits
Health insurance
Flexible working hours
Professional development opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.