Position Overview:

As a Database Analyst and Data Administrator, you will be responsible for managing and maintaining an organization’s databases and ensuring the accuracy, integrity, and security of the data stored within them. You will play a crucial role in optimizing database performance, designing efficient data structures, and implementing data governance and security measures. This position requires a strong understanding of database management systems, data analysis techniques, and data protection regulations.

Key Responsibilities:

1. Database Management: Design, implement, and maintain databases to support organizational needs. This includes creating tables, defining relationships, and establishing data access controls.
2. Data Integrity and Security: Monitor and ensure the accuracy, consistency, and reliability of data by performing regular data quality checks, resolving data issues, and implementing data validation rules. Implement and enforce security protocols to protect sensitive data from unauthorized access.
3. Performance Optimization: Analyze and optimize database performance by fine-tuning queries, indexing data, and implementing caching mechanisms. Identify and resolve performance bottlenecks to improve system efficiency.
4. Data Governance: Develop and enforce data governance policies and procedures to ensure compliance with data protection regulations (e.g., GDPR, HIPAA). Establish data standards, naming conventions, and data classification guidelines.
5. Backup and Recovery: Implement database backup and recovery strategies to safeguard data against potential data loss or system failures. Regularly test backup procedures to ensure data recoverability.
6. Data Analysis and Reporting: Perform data analysis to identify trends, patterns, and insights. Generate reports and visualizations to present findings to stakeholders, enabling data-driven decision-making.
7. Database Documentation: Create and maintain database documentation, including data dictionaries, entity-relationship diagrams, and data flow diagrams. Document database changes, upgrades, and troubleshooting procedures.
8. Collaboration and Support: Collaborate with cross-functional teams, including software developers, system administrators, and business analysts, to understand data requirements and provide technical support. Assist in data migration and integration projects.

Qualifications and Skills:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Analyst, Data Administrator, or a similar role.
• Strong knowledge of relational database management systems (RDBMS) such as Oracle, MySQL, or SQL Server.
• Proficiency in SQL and database programming languages.
• Familiarity with data modeling, database design principles, and normalization techniques.
• Understanding of data governance principles, data protection regulations, and industry best practices.
• Experience with data analysis, data profiling, and data visualization tools.
• Ability to identify and resolve database performance issues.
• Excellent problem-solving and analytical skills.
• Strong attention to detail and ability to handle multiple tasks simultaneously.
• Effective communication and interpersonal skills.