Guide design of new databases and their structures including architecture to streamline data collection and reporting
Review current databases including procedures, queries, and database packages/jobs to see where improvements can be made and give guidance on how to enhance and streamline
Architect, analyze, evaluate performance of the queries being used to access the current
Work with staff to move eligible databases to Cloud SQL
Database development work as needed to support
Produce database related technical documentation as
Any other tasks necessary for completion of project deliverables and database
Provide technical solutions for large scalable designs with a focus on moving what we can to the cloud
Communicate effectively with both technical and nontechnical
Communicate with programmatic units to translate
business requirements into technical
MANDATORY SKILLS/EXPERIENCE
84 months experience designing/architecting Oracle 11g/12c databases and schemas
84 months experience performing Oracle 11g/12c database development. Experience should include development using PL/SQL, packages, stored procedures, triggers, and overall creation of relevant objects and
84 months experience in developing and tuning complex SQL queries for high throughput systems
60 months experience managing cloud databases including setup, configuration, and scaling using RDS or CloudSQL
48 months experience setting up dataflows and querying cloud data warehouses like BigQuery or
84 months support of databases for large scale enterprise systems running 24/7 with large amounts of data
Hiring for a Skilled Revit Technical Architect with 8+ years of experience to work with an extremely well known firm in the industry on a large complex design build