What are the responsibilities and job description for the Database Developer position at TekJobs?
Job Description
Responsibilities:
- Database design: Design and implement efficient database structures and schemas to support application functionality Code writing: Write and optimize complex SQL queries for data retrieval, manipulation, and reporting Database queries: Write SQL queries to extract and manipulate data Testing and troubleshooting: Test databases and identify and fix issues related to performance, security, or data integrity Software specifications: Research, design, document, and modify software specifications Business requirements: Analyze the company's data need and assist in data migration and transformation projects to support business needs
- Collaboration: Work across IT teams and with business users understand the business needs and translate it to implementation.
- Security processes: Develop security processes Best practices: Develop and maintain documentation for database schemas, procedures, and best practices
- Standards: Verify that all database programs adhere to the organization’s and performance standards.
- Database performance: Assess the effectiveness and performance of database systems and applications
Requirements and Skills:
- 5-7 years of experience working in Oracle and DB2 Databases.
- Proven work experience as a Database developer.
- In-depth understanding of data management (e.g. data discovery, data analysis, transformation, data quality, security and monitoring).
- SQL Tuning techniques to prevent performance degradation and understanding on how to use Explain Plan/Query Analyzer/Optimization Tool is required.
- Knowledge of software development and Agile delivery methodology.
- Proficiency in working with specific database like DB2, Oracle & SQL server.
- Working knowledge of ETL processes and tools (i.e., Informatica for data extraction, transformation, and loading from various sources into existing databases) Excellent analytical and organizational skills.
- Understanding the needs of front-end users and having a problem-solving mindset.
- Excellent verbal and written communication skills.
