Database Architect

The Database SQL/Oracle Expert is responsible for managing and optimizing SQL and Oracle database systems within the organization. This role involves designing, implementing, and maintaining database solutions, ensuring data integrity, availability, and performance. The expert will provide technical expertise, support database-related projects, and collaborate with development teams to enhance database functionality.

Key Responsibilities:

Database Management:

• Design, implement, and maintain SQL and Oracle database systems.

• Ensure database schemas, tables, indexes, and queries are optimized for performance and scalability.

• Monitor database performance and troubleshoot issues such as slow queries, locking, and connectivity problems.

• Implement database security measures, including user access controls, data encryption, and auditing.

Performance Tuning and Optimization:

• Conduct database performance tuning and optimization to improve query performance and overall system efficiency.

• Analyze and resolve performance bottlenecks using performance monitoring tools and techniques.

• Implement best practices for database design, indexing, and query optimization.

Backup and Recovery:

• Develop and implement database backup and recovery strategies to ensure data availability and disaster recovery readiness.

• Perform regular backups, test restore procedures, and maintain backup integrity.

• Monitor and manage database replication and synchronization processes.

Database Security:

• Ensure database security policies and procedures are implemented and adhered to.

• Monitor database access and activity logs for unauthorized access attempts or security breaches.

• Implement data encryption and masking techniques to protect sensitive data.

Technical Support and Troubleshooting:

• Provide technical support and troubleshooting for database-related issues.

• Collaborate with development teams to optimize database usage in applications.

• Investigate and resolve database-related incidents and service requests in a timely manner.

Documentation and Training:

• Document database architectures, configurations, procedures, and best practices.

• Provide training and knowledge transfer to other team members on database technologies and best practices.

• Develop and maintain technical documentation for database systems and processes.

Education and Experience:

• Bachelor’s degree in Information Technology, Computer Science, or a related field.

• Minimum of 8 years of experience in database administration, with a focus on SQL and Oracle databases.

• Proven track record of managing and optimizing large-scale database environments.

Technical Skills:

• Expertise in SQL and Oracle database management and administration.

• Proficiency in database performance tuning, optimization, and troubleshooting.

• Experience with database backup and recovery solutions (e.g., RMAN, Data Guard).

• Knowledge of database security principles and best practices.

• Familiarity with database replication, clustering, and high availability solutions.

Soft Skills:

• Excellent communication and interpersonal skills.

• Strong problem-solving and analytical abilities.

• Ability to work effectively in a team and independently.

• Strong organizational and multitasking abilities.

• Client-focused with a strong customer service orientation.

Certifications:

• Relevant certifications such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, or similar are highly desirable.

• Additional certifications in ITIL, CISSP, or other relevant areas are a plus.