Database Developer- Remote

Sausalito, CA 94965

Posted: 07/09/2020 Job Category: Big Data Engineer Job Number: 140992

Job Description


Title:  Sr. Database Developer- Remote
Location: San Francisco, CA
Company: Investment Management

**Candidates MUST be a US citizen or have a greencard- NO C2C!**

In this role, you will be the Postgres ninja  and will play a key role in developing and maintaining the  technology base and delivering new platform functionality. You will  be responsible for developing and supporting the databases, data structures, and data flows that support the  business and application development requirements with a focus on data integrity and security.

 

This position is roughly 50% database development, 20% database administration, 20% ETL development and 10% other tasks.

 

WHAT YOU WILL BE DOING:

Work with the Systems Architect and other teams  to create  data models/database structures to facilitate project requirements and new requests for data:
  • Creating normalized tables
  • Writing functions and views
  • Maintaining and refactoring legacy schemas
  • Modeling and/or documenting database objects
  • Meeting with business stakeholders and other technical team members to gather and analyze application requirements
  • Designing database solutions to satisfy business requirements
  • Assisting Application Developers with the creation of queries and database functions, provide guidance on performance and optimization
  • Developing and supporting ETL processes to improve quality and integrity of data imports
  • Performing administrative, maintenance, monitoring, and performance tuning tasks on the database
  • Identifying and applying proactive solutions and corrective measures to minimize downtime
  • Troubleshooting and providing configuration and maintenance support for production and development database environments
  • Creating and maintaining scripts to automate common operations and maintenance tasks
  • Assist with report development and maintenance

WHAT WE WANT TO SEE:
  • 7+ years of database development experience supporting application development teams/projects
  • Experience in the financial or investment sector REQUIRED
  • Expert SQL writing and query optimization skills
  • Advanced knowledge of Postgres VERY highly preferred
  • Strong understanding of, or experience with, DBA tasks supporting relational databases in an enterprise environment, including Postgres 9.6 or higher
  • Strong understanding of data modeling and enterprise database concepts
  • Strong experience with ETL job development and maintenance preferred
  • Report writing or development experience desirable
  • Python development experience desirable
  • AWS environment experience desirable

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.