DBA/Database Developer at Aperio group, LLC (Sausalito, CA)

As a DBA/Database Developer, you'll be a part of our highly collaborative team and play a key role in developing and maintaining our technology base and delivering new platform functionality. You'll be responsible for developing and supporting databases, and data structures in support of business and application development requirements with a focus on data integrity and security.                           

 Duties and Responsibilities

 The DBA/Dev’s responsibilities are divided into the two following areas:

  DB Administration:

• 
  
•  Perform administrative, maintenance, monitoring, and performance tuning tasks on the database.
• 
  
• Identify and apply proactive solutions and corrective measures to minimize downtime.
• 
  
• Troubleshoot and provide configuration and maintenance support for production and development database environments.
• 
  
• Generate and maintain scripts to automate common operations and maintenance tasks.
• 
  
• Maintain and enhance existing security policies and procedures.
• 
  
• Perform routine or other job-related duties as assigned.
• 
  

 DB Development

• 
  
•  Work with the Sr. Data Architect to create performance and extensible data models/database structures to facilitate new requests for data or project requirements.
• 
  
• Meet with business stakeholders and other technical team members to gather and analyze application requirements.
• 
  
• Design database solutions to satisfy business requirements.
• 
  
• Assist Application Developers with the creation of queries and database functions, provide guidance on performance and optimization.
• 
  
• Develop and support ETL processes to improve quality and integrity of data imports.
• 
  

 Required Skills/Experience

Language Skills: Read, write, and speak English fluently.  Ability to communicate and follow up effectively and professionally with other business departments.

Must have related experience in the financial or investment sector.

 Technical Skills:

• 
  
• 5+ years of DBA experience supporting relational databases (Postgres, SQL Server, or Oracle) in an enterprise environment.
• 
  
• Advanced knowledge of Postgres highly preferred.
• 
  
• 5+ years of database development experience or related experience supporting application development teams/projects.
• 
  
• Expert SQL writing and query optimization skills.
• 
  
• Strong understanding of data modeling and enterprise database concepts.
• 
  
• 2+ years of Python or other OO development experience
• 
  

by via developer jobs - Stack Overflow