We are seeking a skilled and detail-oriented Database Developer to design, develop, implement, optimize, and maintain databases and data-driven applications. The Database Developer will be responsible for developing database structures, writing complex queries and stored procedures, improving database performance, maintaining data integrity, and supporting applications that rely on business-critical data. The ideal candidate has strong SQL and database development skills, excellent analytical abilities, and experience working with relational databases and data-management technologies. ## Key Responsibilities - Design, develop, and maintain relational databases and database structures. - Write, test, and optimize SQL queries, stored procedures, functions, triggers, and views. - Develop database schemas, tables, indexes, relationships, and data models. - Analyze business and technical requirements and translate them into effective database solutions. - Optimize database performance by analyzing queries, indexes, execution plans, and database configurations. - Ensure data accuracy, integrity, consistency, availability, and security. - Develop and maintain ETL processes for importing, transforming, and loading data. - Integrate databases with applications, APIs, reporting systems, and other data platforms. - Create and maintain database documentation, data dictionaries, and technical specifications. - Troubleshoot database-related errors and performance issues. - Monitor database health, performance, storage, and resource utilization. - Assist with database upgrades, migrations, backups, and recovery procedures. - Collaborate with software developers, data engineers, analysts, system administrators, and business stakeholders. - Develop reports, dashboards, and data extracts when required. - Perform data validation, cleansing, and quality checks. - Implement appropriate database security, access controls, and permissions. - Participate in database architecture and technology decisions. - Review database code and provide recommendations for performance and maintainability. - Maintain development, testing, and production database environments. - Support disaster recovery and business continuity procedures. - Stay current with database technologies, development practices, and security standards. - Perform other database and technical duties as assigned. ## Required Qualifications - Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field, or equivalent practical experience. - Professional experience in database development or a related technical role. - Strong SQL programming skills. - Experience with relational database management systems such as Microsoft SQL Server, PostgreSQL, MySQL, or Oracle. - Knowledge of database design, normalization, relationships, indexes, and constraints. - Experience developing stored procedures, functions, views, and triggers. - Strong understanding of database performance optimization. - Knowledge of data integrity and security principles. - Experience with version control systems such as Git. - Strong analytical and problem-solving skills. - Excellent communication and collaboration abilities. ## Preferred Qualifications - 2+ years of professional database development experience. - Experience with Microsoft SQL Server, Oracle, PostgreSQL, or MySQL. - Experience with ETL tools and data integration platforms. - Familiarity with cloud database services such as AWS, Microsoft Azure, or Google Cloud. - Experience with database migration and modernization projects. - Knowledge of data warehousing and dimensional modeling. - Experience with Power BI, Tableau, or other business intelligence platforms. - Familiarity with NoSQL databases such as MongoDB, DynamoDB, or Cassandra. - Experience with database automation and CI/CD practices. - Knowledge of database backup, recovery, replication, and high-availability solutions. - Familiarity with Python, Java, C#, or another programming language. ## Technical Skills - SQL - Microsoft SQL Server - PostgreSQL - MySQL - Oracle Database - Database design and modeling - Stored procedures - Functions and triggers - Views and indexes - Query optimization - Performance tuning - ETL / ELT - Data migration - Data warehousing - Database security - Backup and recovery - Git / version control - Cloud databases - REST APIs and application integration - Power BI / Tableau - Python or other programming languages ## Key Competencies - Analytical thinking - Problem solving - Attention to detail - Data accuracy - Technical troubleshooting - Database architecture - Performance optimization - Communication - Teamwork - Organization - Time management - Security awareness - Continuous learning ## Performance Expectations The successful candidate will be expected to: - Develop reliable, scalable, and efficient database solutions. - Maintain high standards of data quality and integrity. - Optimize database performance and resolve issues promptly. - Deliver database development projects within established timelines. - Follow company security, development, and documentation standards. - Maintain accurate technical documentation. - Collaborate effectively with development, IT, analytics, and business teams. - Protect sensitive and confidential data. - Identify opportunities to improve database performance, reliability, and maintainability. ## Work Environment This position may be performed in an office, remote, or hybrid environment depending on company requirements. The role involves extensive computer use, database development, technical troubleshooting, documentation, and collaboration with technical and business teams. ## Physical Requirements - Ability to work at a computer for extended periods. - Ability to read technical documentation and database information on computer screens. - Ability to participate in virtual or in-person meetings. - Reasonable accommodations may be provided to qualified individuals with disabilities. ## Compensation & Benefits Compensation will depend on experience, technical skills, location, and company pay structure. Benefits may include: - Medical, dental, and vision insurance - Paid time off - Paid holidays - Retirement plan or 401(k) - Performance bonuses - Professional development and training - Certification assistance - Remote or hybrid work options - Employee technology benefits, where applicable