- Develop, test, and maintain the database code
- Create or modify database objects and/or write SQL code in support of application needs
- Monitor and improve database performance and capacity
- Ensure that database systems are safeguarded and implement necessary security measures to ensure data integrity
- Assist with upgrading database for new version release when needed
- Syncing data across data sources
- Conduct research on emerging database and application development software products, languages, and standards in support of development efforts
What are we looking for?
Technical SkillsThe following skills are needed for this role.Experience:
- Must have Expert level (5+ years) hands-on database development experience and skills and database maintenance experience) in MS SQL Server
- Excellent (5+ years) hands-on database experience and skills in developingMS SQL ServerStored Procedures, functions, triggers, queries, scripts, etc.
- Excellent (3+ years) hands-on MS SQL Server database experience in troubleshooting, performance tuning, debugging, and query optimization in MS SQL Server
- Excellent (3+ years) in indexing, finding and resolving potential for database deadlocks
- Experience in MS SQL Server database migrations and upgrades.
- Has experience with analytics and reporting
- Have a MS SQL Server / Azure SQL certification OR are willing to obtain in a short time frame.
- Nice to have experience with: ETL, Azure SQL
- Strong writing skills are essential, as is the ability to work effectively in a fully remote team without the need for a physical office.
- The ideal candidate thrives in a collaborative team environment with a diverse range of people and is passionate about delivering an amazing customer experience.
- They should be adaptable, capable of changing their mind and influencing others
The candidate should have a strong work ethic, be a self-starter with a desire to grow, and consistently seek better ways to accomplish tasks.