What are the responsibilities and job description for the Webilent Technology, Inc. | Senior Database developer onsite in Bloomfield CT or Phoenix, AZ position at Webilent Technology, Inc.?
Database Developer Job Description
Position Overview
We are seeking a skill ed Oracle PL / SQL Developer or PostgreSQL Database Developer to join our team. The ideal candidate will be responsible for designing, implementing, and maintaining PostgreSQL databases that support our applications and services. This role requires a deep understanding of database design, optimization, and administration, as well as the ability to collaborate with cross-functional teams to deliver high-quality solutions.
Key Responsibilities
- Database Design and Development :
- Design and develop PostgreSQL databases to meet application requirements.
- Create and manage database objects such as tables, indexes, views, stored procedures, and triggers.
- Performance Tuning and Optimization :
- Analyze and optimize database performance using indexing, query optimization, and normalization techniques.
- Troubleshoot and resolve database performance issues.
- Data Management and Security :
- Implement and maintain database backup and recovery solutions.
- Ensure data integrity, security, and compliance with organizational and regulatory standards.
- Collaboration and Support :
- Work closely with software developers to design and optimize database queries and schemas.
- Provide support and guidance on database usage and best practices.
- Monitoring and Maintenance :
- Monitor database health, capacity, and performance metrics.
- Conduct regular maintenance tasks, such as patching and updates.
- Automation and Scripting :
- Develop and maintain automation scripts for database tasks using SQL and scripting languages (e.g., Python, Bash).
Requirements
Technical Skills :
Soft Skills :