Administers databases and reports applications including, but not limited to, backup and recovery, performance tuning, query optimization, troubleshooting, security and installation of patches and upgrades.
Design, build and maintain scalable data pipelines and data warehouse solutions. Uses advanced SQL for ETL/ELT processes, data transformation, and integration to support analytics, reporting, and downstream data consumers.
Design, write, and optimize complex SQL queries, stored procedures, functions, and database objects. Works closely with application and reporting teams to support data-driven applications and business intelligence needs.
Gather and analyze business requirements, collaborate with stakeholders, and produce comprehensive database and system documentation to translate functional needs into technical solutions.
Perform daily data updates, monitor database operations, and support day-to-day syst...