What are the responsibilities and job description for the Database Administrator position at Mindlance?
Summary of Work :
This position will plan for, develop, test, and support database migrations to new databases within a Cloud environment.
Minimum Job-Specific Skills / Qualifications Required :
- 5 years' experience designing complex, normalized, relational application databases, including Oracle.
- 5 years' experience designing, developing, and deploying relational databases in a cloud environment, especially Azure and / or AWS, ensuring the integrity and security of the database.
- Experience migrating an on-premises or cloud Oracle DB to any one cloud-based solution such as Azure SQL, MySQL, Azure Oracle in VM, AWS Aurora, or AWS RDS.
- Excellent written and verbal communication skills, with both technical and non-technical audiences.
- Experience analyzing requirements, researching alternatives, and making successful recommendations for database solutions.
- Experience developing and executing successful migration plans from one database solution to another (e.g., Maria DB to MY SQL, Oracle to Azure SQL, not from one Oracle DB to another Oracle DB).
- Demonstrated knowledge and successful execution of the principles and techniques of the full database design, modeling, development, testing, and documentation lifecycle.
- Demonstrated knowledge and successful execution of the principles and techniques of systems implementation, including conversion, data reconciliation, and documentation.
- Experience developing and documenting relational database models, based on functional specifications and conceptual object models.
- Experience developing and documenting database schemas based on relational models.
- Experience building and deploying relational databases based on database design, models, and schemas.
- Experience administering relational databases and conducting performance optimization to meet SLAs.
- Experience analyzing database configuration to research and resolve database and application issues.
- Extensive experience with function and stored procedure packages using SQL.
- Experience with database performance monitoring and tuning tools and techniques.
- Experience developing data scrubs to correct data based on knowledge of the application.
- Principles of information systems architecture for enterprise-wide systems deployment such as multi-tier, web based, distributed system architecture and development principles, and internet / intranet application delivery mechanisms.
- Experience coordinating with 3rd party vendors to resolve database software issues.
dditional Skills / Qualifications Desired :
