Job Description
Job Objective:
- All the applications that we build and currently maintain use complex databases to function properly.
- We need a database developer to design, implement and maintain programs that enable users and administrators to update, retrieve, delete, or arrange data within our databases.
- He/she will be an integral part of our development team and will be the first respondent to database problems that arise and carry out periodic maintenance and troubleshooting
Duties & Responsibilities:
- Gather user requirements and identify new features
- Writing efficient code
- Working closely with web designers and programmers to produce functional web applications
- Constant communication with other colleagues in the business to develop and deploy their content and ensure there is a clear establishment of what can be created within what timeframe
- Maintaining software (database) documentation – creating and maintaining data dictionaries for all our applications.
- Design stable, reliable, and effective databases
- Optimize and maintain legacy systems
- Modify databases according to requests and perform tests
- Solve database usage issues and malfunctions
- Develop and maintain ETL routines
- Provide data management support to users
- Ensure all database programs meet company and performance requirements
- Research and suggest new database products, services, and protocols
- Gather and refine specifications and requirements based on technical needs
- Stay plugged into emerging technologies/industry trends and apply them to operations and activities
- Ability to multitask with strict time constraints, budgets, and business goals
- Develop, implement, and test disaster recovery strategy
- Supervise and develop less experienced team members.
Education/Knowledge, Skills, Attributes, Experience & Other Requirements:
- Bachelor’s Degree in Computer Science, Statistics, or a relevant field
- Advanced certification as an MCDBA or MCSD for .NET is advantageous.
- Excellent knowledge of MS SQL Server and MySQL
- Familiarity with MongoDB and PostgreSQL
- 5+ years’ experience in the use of stored procedures, views, triggers, and functions.
- Proven working experience as a database Developer
- In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
- A functional knowledge of business intelligence data mining and analysis tools (e.g. Power BI, Tableau) will be advantageous.
- Creative problem-solving skills
- Strong organizational skills to juggle multiple tasks within the constraints of timelines and budgets with business acumen
- Ability to work and thrive in a fast-paced environment, learn rapidly, and master diverse web technologies and techniques.
- Excellent written and verbal communication skills, with strong attention to detail, and a head for problem-solving. and teamwork skills
- Great attention to detail
- Organizational skills
- An analytical mind
Skillset required:
- T-SQL and MySQL scripting experience (mandatory)
- Azure Database Administration
- Experience with server-side frameworks such as Java, ASP, ASP.NET – C# (advantageous)
- At least one of Tableau, Metabase or PowerBI • Azure Data Factory