Required Skills :
- Proven experience as a Database Administrator with specific experience in data migration projects
- Extensive knowledge of database design, documentation, and coding
- Knowledge of the development and management of computer system databases and data warehouses
- Knowledge and / or experience with mainstream SQL databases
- Strong analytical, research, and organizational skills, with impeccable attention to detail
- Understanding and experience with cloud services
- System administration skills
- Knowledge of CI / CD Pipelines
- Good understanding of database version control
- Ability to test and troubleshoot software using appropriate methodologies and techniques
- Excellent written / verbal communication, interpersonal, and organizational skills required
- Understand the principles, theories, and practices of computer science
- Deal with people in a manner that shows sensitivity, tact, and professionalism
Our client is looking for an experienced Engineer working on SQL databases hosted on Windows and Linux servers with a strong focus on database migration, re-platforming, and adoption of cloud computing services.
The ideal candidate will lead our transition from Informix to a more modern, mainstream database management system; PostgreSQL hosted on AWS cloud services to enhance our data processing capabilities and support future scalability and performance needs. The chosen candidate will also provide interim database maintenance, support, and administration supporting various applications while cross-training in-house support staff to assume those duties and responsibilities long term. This role is crucial for ensuring that the CLIENT remains competitive and capable of meeting the demands of our customers with efficient, reliable, and scalable database solutions
Primary Duties & Responsibilities
Develop and implement a comprehensive database migration strategy from Informix to a more modernized and scalable database system.Conduct thorough assessments of current database structures, data volumes, and system integrations.Design and manage database schemas ensuring they meet functional requirements and performance goals.Lead the migration process, including data cleansing, migration scripting, data validation, and post-migration testing.Collaborate with IT teams to ensure smooth integration with other enterprise applications.Monitor system performance post-migration and optimize as needed to meet performance targets and provide ongoing maintenance, support, database integrity, troubleshooting, performance assessments, and enhancements in database services.Develop and enforce best practices for database management, security measures, and disaster recovery plans.Document all processes related to database migration and routine maintenance as well as documentation of existing database systemsOnly those lawfully authorized to work in the designated country associated with the position will be considered.Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.