Database Administrator
CurrentAs a DBA, I work with the International Group of Airlines, focusing specifically on British Airways under Coforge employment. My role is pivotal in managing and optimizing database systems to ensure their robustness, performance, and availability, crucial for the airline's operational efficiency.Key Responsibilities:Schema Design: Designing the database schema to ensure efficient data storage, retrieval, and integrity.Database Creation: Setting up databases and configuring… Show more As a DBA, I work with the International Group of Airlines, focusing specifically on British Airways under Coforge employment. My role is pivotal in managing and optimizing database systems to ensure their robustness, performance, and availability, crucial for the airline's operational efficiency.Key Responsibilities:Schema Design: Designing the database schema to ensure efficient data storage, retrieval, and integrity.Database Creation: Setting up databases and configuring them according to organizational needs.Backup and Recovery: Establishing backup procedures and ensuring that they are regularly followed.Access Control: Setting up and managing user roles and permissions to ensure only authorized users have access to certain data.Audit: Monitoring and auditing database access and actions to detect and prevent unauthorized activities.Data Quality Management: Implementing and managing tools and processes to ensure high data quality.Problem Resolution: Diagnosing and resolving database issues, including performance problems, data corruption, and connectivity issues.User Support: Providing support to developers, analysts, and end-users on database-related issues.Monitoring Tools: Using monitoring tools to track the performance, availability, and security of databases.Documentation: Maintaining comprehensive documentation of the database environment, including configuration, processes, and procedures.Team Collaboration: Working closely with IT teams, developers, and data analysts to meet organizational goals.Technologies Used:DBMS : Oracle, AWSTools: SQL Developer, SQL PLUS, PuTTyBackup & Recovery: RMANPerformance Monitoring: SQL ProfilerSecurity: Encryption, Auditing, User Access Management Show less