Design logical and physical data models along with collaring, preparing and presenting statistical information for both internal and external use.
Ensure database optimization, integrity, consistency, security and privacy.
Providing support, guidance and collaborating with Application Developers to implement database design, and review developer’s work to ensure correct implementation & provide 3rd level support.
Create scripts to build new database objects.
Develop stored procedures, functions, packages, triggers and views using T-SQL.
Assist with schema design, code review and SQL query tuning.
Participate in SQL code reviews, write and deploy SQL patches, and gain a deeper understanding of mirroring and SQL clustering.
Continually evaluate software components and tools for software applications, making recommendations for system improvements as required.
Upgrade and improve data and application schema, preparing design documents and functional specifications.
Able to manage other RDBMS such as oracle, PostgreSQL etc.
Database Developer Requirements:
4+ years working as a database developer, database administrator or in a related role.
Bachelor’s Degree in Engineering or Computer Science.
2 or more years of handling a database environment of more than 300GB, with strong data analysis and analytical skills.
SQL server administration experience, including knowing the basics of running Microsoft SQL Server — users, permission, backups, recovery, monitoring, and more.
Ability to create SQL reports.
Database tuning experience, database integration design and implementation, and management of database projects.
Ability to work with a team in an Agile environment—you can address bugs with QA, plan schemas with engineering, and respond quickly to other business needs.
Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.
ETL experience is a plus.
Highly organized and self-motivated with the ability to prioritize projects, meet deadlines, and make room for emergencies, as needed.