Serve as the primary technical resource for designing, managing, and documenting databases (Oracle, MySQL, SQL Server, Postgres), ensuring continuous access and system stability.
Safeguard vital data with robust security measures, perform regular backups, and maintain documentation of backup/recovery plans.
Optimize database performance and capacity across all environments (production, QA, development), including conducting audits to maintain security and performance.
Develop SQL procedures for enterprise database queries, updates, and performance tuning; ETLs, security, and availability.
Implement security by design within databases and oversee the in-house security of all databases, minimizing the reliance on third-party solutions; conduct periodic audits for security improvements.
Assist with system changes, new implementations, and IT budget planning by recommending database-related equipment, software, and upgrades.
Collaborate with IT teams on system integrity, availability, and security, while supporting internal applications and the AD Public & Private Websites.
Archive and manage historical data for performance optimization and data management.
Experience Requirements
2 - 3 years
Educational Requirements
Bachelor/Honors
Skills
Ability to meet productivity and quality standardsExcellent communication skillsSuperior customer service skillsBachelor's degree in Computer Science, Business Administration, or equivalent experience.Proficient in writing complex SQL queries.Experience working in both Windows and Linux operating systems.Familiarity with extraction, transformation, and loading (ETL) tools.Experience migrating databases to cloud platforms (AWS, Azure, Oracle) is a plus.