Ready to make an impact?

Experience: 10+ Years

Job type: Full time

Essential functions and responsibilities: 

• UML: Create UML diagrams (class diagrams, sequence diagrams, activity diagrams, etc.) to visually represent system architecture, component interactions, and workflows, facilitating better understanding of system design.
• Data Modeling: Create and interpret Entity Relationship Diagrams (ERDs), which are visual representations of how different entities (tables) in a database are related to each other, allowing them to effectively design and understand complex database structures. Design detailed ERDs to capture the logical data model of a database, including cardinality and constraints.
• Data Collection and Integration: Extract development data from various sources like code repositories, project management systems, bug tracking tools, and build automated data pipelines to ensure consistent data flow.
• Data Cleaning and Preprocessing: Identify and address data quality issues, including missing values, inconsistencies, and outliers, to prepare data for analysis.
• Data Analysis and Insights: Analyze development data using statistical methods to identify trends, patterns, and key performance indicators (KPIs) related to development velocity, code quality, defect density, and project timelines.
• Performance Metrics: Monitor and report on development metrics like code coverage, cyclomatic complexity, and code churn to pinpoint areas for improvement.
• Reporting and Visualization: Create clear and concise data visualizations (dashboards, reports, graphs) using data visualization tools to effectively communicate insights to stakeholders.
• Collaboration: Work closely with development teams, project managers, and other stakeholders to understand their needs, gather relevant data, and interpret analysis results.
• Process Improvement: Identify opportunities to optimize development processes based on data analysis findings and propose actionable solutions to improve efficiency and quality.

Knowledge, skills, and abilities: 

• DB Skills: Must have understanding of technologies consisting of but not limited to MariaDB/MySQL, NoSQL, PostgreSQL (MongoDB, Cassandra etc…).
• Technical Skills: Proficiency in data analysis tools (SQL, Python, R), data visualization tools (Tableau, Power BI), and UML modeling software.
• Software Development Understanding: Familiarity with software development methodologies (Agile, Waterfall), common development tools, and code repositories.
• Analytical Skills: Strong analytical thinking, ability to identify patterns and trends in complex data sets.
• Communication Skills: Excellent communication skills to effectively present data insights to both technical and non-technical audiences.
• Problem-Solving Skills: Ability to identify problems, analyze root causes, and propose solutions based on data analysis.

Education and background: 

• Bachelor’s degree in computer science or related discipline is required; experience may substitute for the education requirement.
• >5 years’ experience with Relational Databases e.g. MariaDB/Mysql/NoSQL and above required.
• >3 years’ experience as a DB Analyst.

Experience: 5+ Years

Job type: Full time

Key Responsibilities of a DBA Manager:

1. Team Leadership: Lead and manage a team of database administrators, including responsibilities for hiring, training, and performance management.
2. Policy Development: Develop and implement database policies, procedures, and best practices to ensure optimal performance, security, and compliance.
3. Performance Monitoring: Monitor and analyze database performance metrics, identifying and addressing issues or bottlenecks to maintain high efficiency.
4. Collaboration: Work closely with IT and business stakeholders to understand database requirements and devise solutions that meet those needs.
5. Upgrade Management: Plan and oversee database upgrades, patches, and migrations to ensure smooth transitions and system improvements.
6. Data Security: Implement and enforce data integrity and security measures, including access controls, encryption, and other security protocols.
7. Technical Support: Troubleshoot and resolve database issues, providing support to the team in addressing technical problems.
8. Industry Awareness: Stay updated on industry trends and best practices in database management to keep the organization aligned with current standards.
9. System Health Monitoring: Monitor the health of database servers through both automated and manual processes, recommending and implementing performance tuning solutions.
10. Problem Analysis: Analyze problems, anticipate future issues, and implement effective solutions to mitigate potential risks.
11. Environment Configuration: Oversee environment setup, configuration, proactive monitoring, and maintenance tasks.
12. Requirement Support: Support the development of long- and short-term database administration and design requirements.
13. Change Control: Participate in the change control process for all planned application and technical activities, ensuring controlled and orderly changes.
14. Reporting: Collaborate with report writers to provide necessary data for report generation and analysis.
15. Project Management: Manage full roadmap items, coordinating with other functional teams to deliver high-quality results on time.
16. Root Cause Analysis: Investigate and determine the root causes of software problems reported by stakeholders, implementing corrective actions as needed.
17. Database Design: Direct the organization of requirements and data into a usable database schema, including the development of ad hoc queries and scripts.
18. Administrative Tasks: Perform database administration and maintenance tasks, such as installation, configuration, backups, upgrades, and patching.
19. Code Review: Review SQL code written by application developers to ensure compliance with coding standards and performance optimization.
20. Performance Evaluation: Evaluate the performance of stored procedures, identifying resource-intensive areas and providing recommendations to developers.
21. Deployment Management: Create deployment and rollback scripts for database objects, ensuring smooth updates and recovery processes.
22. Indexing and Query Optimization: Analyze access patterns to propose optimal combinations of indexes, constraints, foreign keys, and queries.
23. Technical Enhancements: Proactively identify technical opportunities and enhancements while addressing major incidents in a timely manner.
24. Data Management: Manage and ensure the integrity, security, and retention of data, including administration of end-user accounts, permissions, and access rights.
25. On-Call Support: Participate in an on-call rotation to provide 24/7 support and perform off-hours maintenance as needed.

Knowledge, Skills, and Abilities 

1. Strong understanding of relational database management systems (RDBMS) such as MariaDB, MySQL, PostgreSQL, Oracle, SQL Server, etc. 
2. Proficiency in NoSQL databases such as MongoDB, Cassandra, DynamoDB, etc.
3. Experience with AWS native databases such as Amazon RDS, Amazon Aurora, Amazon DynamoDB, etc.
4. Knowledge of database design principles and best practices.
5. Experience with cloud computing platforms and services, particularly AWS

Education and Experience 

• Bachelor’s degree in Computer Science or a related discipline is required; relevant experience may substitute for formal education. 
• At least 10 years of experience with relational databases such as MariaDB, RDS, MongoDB, Amazon DynamoDB, and PostgreSQL. 
• A minimum of 10 years of experience with automation utilizing shell scripting (Shell, Perl, Python, etc.) is required.