The Role:
Design, implement, configure, administer, maintain and support an array of RDBMS in production, test and development environment that serve OLTP and Data Warehouse applications. The candidate of this position will also work on developing, implementing, and enforcing policies and procedures to ensure the security and integrity of corporate databases. Will provide guidance and lead complex projects regarding database infrastructure and management.
Your Focus:
- Architect and implement enterprise database systems, including the support of advanced configurations such as clustering and replication
- Enforce the company s database policies and procedures
- Maintain enterprise and database servers in production, test and development environments
- Monitor database performance and tune database management system as necessary
- Work closely with system administrators during software installation and upgrades
- Ensure availability of databases in accordance with service level agreements
- Correct problems in databases promptly and accurately
- Review, validate,
and deploy database update during applications rollout to production setting
- Offer assistance to developers in tuning database queries under development
- Support developers when they need to troubleshoot application issues that might be related to database backend
- Lead projects in regarding database infrastructure changes and upgrades
Qualifications
- BS degree in Computer Science, Management Information Systems or a related field
- 5+ years of devoted experience with managing, configuring and maintaining various RDBMS, MySQL, Teradata or Redshift preferred.
- Extensive experience and knowledge of query performance tuning, backup restore, permission architecture and disaster recovery procedures.
- Proven experience with complex database systems migration, consolidation, and integration
- Familiarity with data warehousing methodologies and technologies
- Skilled with hands-on SQL programming for ext