Software Database Design Engineer

About the job

Position Summary:

The Software Database Design Engineer creates, maintains, and enhances databases using SQL/PostgreSQL, and Python. Responsible for creating schemas, optimizing and enhancing databases & queries used in the creation of high-definition maps for autonomous vehicles. Must have at least ten year's experience in database design and maintenance with involvement in Software Development Life Cycle - SDLC process in a fast-paced, small team environment.

Main Duties and Responsibilities:

• Design and implement relational databases, schemas, and queries.
• Optimize databases for performance, scale, and storage.
• Use Database development tools (pgAdmin) to create, maintain and enhance databases.
• Resolve database infrastructure-related issues, provide guidance on systems architecture and data model, and SQL query reviews.
• Use PostgreSQL replication technologies including Master-Master multi-replication, and Master-Multiple Slave replication.
• Perform PostgreSQL administration and support including backup and recovery, replication, clustering, performance tuning, and monitoring.
• Manage Application servers for data integration and reporting applications.
• Work in a highly segmented network with complex firewall implementations and security features.
• Code in the procedural language for at least one database engine using (PL/SQL etc.) and scripting language like Python.
• Perform manual database-related tasks and build automation wherever possible to replace those tasks.
• Use debugging skills to design and test the databases and release them into production.
• Work with internal and external customers to integrate the database with the tools, test and launch successfully for customer delivery or operations use or R&D.
• Develop high-quality software and make efforts to find and fix defects before release.
• Create documents and best practices as necessary.
• Follow the software, DevOps and production process.
• Proficient in presenting design or software concepts to customers, management and team members

Skills, Qualifications, and Competencies:

• BS in Software Engineering, Computer Science, Computer Engineering or equivalent
• 5+ years of Experience creating, designing, installing, upgrading and maintaining databases.
• Experience with Big Data (10TB+) database administration.
• Experience building and maintaining complex mission-critical production database systems
• Deep knowledge and experience designing and maintaining PostgreSQL relational databases
• Expertise with Amazon Web Services Relational Database Service (RDS)
• Python scripting/development and/or other scripting and high-level programming languages like Python, C++
• Experience and expertise with Postgres
• Experience and expertise with SQL
• Experience with Spatial Database design
• Experience with LIDAR, GIS (Nice to have)
• Strong communication and leadership skills
• Experience with Psycopg2 (Nice to have)
• Experience with QGIS and/or ArcGIS (Nice to have)
• Experience interacting with resolving database engine and system/infrastructure-related issues and providing guidance on systems architecture, data model, and SQL query reviews as needed.
• Experience with PostgreSQL replication technologies including Master-Master multi-replication, and Master-Multiple Slave replication.
• PostgreSQL administration and support experience including backup and recovery, replication, clustering, performance tuning, and monitoring.
• Familiarity managing Application servers for data integration and reporting applications.
• Conduct root cause analysis.
• Experience working in a highly segmented network with complex firewall implementations and many security features.
• Proven track record mastering manual database-related tasks and building automation wherever possible to replace those tasks.
• Experience in Agile Methodology.