Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Job Description: Does this position have the potential to convert to direct? Yes
o If yes, what is the conversion salary? TBD
What is a day in the life like for the person in this role?
Are there other skills/certifications required that are not listed in the job description? No
What are your non-negotiable requirements? 3 days to office and Strong Postgres DB
What does the interview process look like? Interview by 2-3 leads. Preferably in person at office TX590
What are 2 or 3 prescreen questions you would like to have the vendor ask the candidates and provide the answers to along with their resume submittals?
Have you worked on AWS RDS ?
How many years' of working on Postgres ?
What is the largest Production DB size supported?
What is the lift requirement for this assignment? n/a
Work Shift - What are the work days and hours? Standard 9-5 , occasional support to manage issues and/or escalations.
How long do you anticipate the assignment to last? 1 Year
o What is the possibility of extension? TBD
Work Location Is this position onsite or remote? Partially remote
o If remote, is it fully or partially remote?
o If partially remote, how many days per week will the person be expected to be onsite? 3 days per week on site
o If onsite, what is the onsite address or location code? TX590 , 2375 N Glenville Dr Bldg A, Richardson, TX 75082
What are the selling points of the location (if onsite) to attract candidates? n/a
What is the COVID protocol for the site? n/a
Will the contractor be issued a laptop? Yes
Bill rate to CBRE?
What Background investigation package is required for this assignment?
Is a drug screen required? CBRE standard no drug test
o If yes, what panel?
Is there any client specific paperwork required?
What is the FMC Code? 411409.100004.NONCL
What is the Project ID? 2022 CBREOne
What is the account + activity code?
o 90% capex -- 162800.1CIPA.OCSLT_CAP_COST
o 10% Opex - 557000.5OTOP.OTHEX_EXPENSE
Additional information n/a

DateHYBRID 3 DAYS WORK FROM OFFICE

Experience in AWS or Azure.
Experience designing/managing Postgres, MySQL, Snowflake.
SQL statement tuning - Reviewing and Implementing Database design changes
Coding (procedures, functions, packages, triggers, etc.)

Technical Requirement
Provide technical expertise and support in the use of Postgres RDS.
Define file organization, indexing methods, and security procedures for specific user applications.
Create and maintain database objects such as tables, views, index, constraints for data platform and custom applications.
Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the RDS and in line with other platform procedures and processes.
Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and available/approved 3rd party tools.
Design and develop logical and physical database designs from application requirements.
Design and implement automation using scripts and database functions.
Implement replication and backups for mission critical/tier-1 applications in line with platform procedures and processes and RDS best practices.
Create/enhance and maintain database design, naming and other standards and periodically assess compliance to such standards through publishing standard reports
Provide development and technical support primarily for SQL programming and as needed for Python scripting, to accomplish stated objectives.
Perform testing and validation to ensure performance and defect free code delivery to meet and exceed requirements. This includes tuning and optimizing developed SQL, guiding developers to optimize and utilize best practices for SQL development.
Monitor database and related systems performance and support troubleshooting and optimizations as required. Perform debugging on database scripts & program and resolve conflicts.
Additional Sills: