Responsibilities:
We are looking for a SQL developer with skills in database administration who will be responsible for understanding how to set databases up for production usage and ensuring their stability, reliability, and performance. You will also work with other developers optimizing in-application SQL statements as necessary and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.
Additional responsibilities for owning and extending an ETL solution using SSIS to transform data from an operational data store into a Data Warehouse.
Duties:
· Help write and optimize in-application SQL statements
· Ensure performance, security, and availability of databases
· Prepare documentation and specifications
· Handle common database procedures such as upgrade, backup, recovery, migration, etc.
· Profile server resource usage, and optimize and tweak as necessary
· Collaborate with other team members and stakeholders
· Build/Extend ETL Solution using SSIS
· Work with Clients/Support to monitor and optimize client database setups
Competencies
· Thinks outside the box, questioning ideas, solutions and processes, and looking for continuous improvement.
· High quality of work & attention to detail:
o Shows concern for quality, accuracy, and completeness of work activities
o Personally, seeks to add value in every work assignment
o Notices opportunities to improve quality and takes action to do so
o Expresses concern that things be done correctly, thoroughly or precisely
o Shows dedication to producing high-quality software
· Analytical & Problem Solving:
o Analysing situations to determine the root cause
o Asking the correct questions to clarify issues & design
o Thinking ahead and anticipating what might happen
o Designing solutions, incorporating both technical & business needs
o Ability to multitask and worth with many stakeholders
· Shows initiative:
o Going beyond expectations in tasks without being asked
o Self-motivated and willing to take on additional responsibility
o Willingness to learn new skills and continuously train in order to keep abreast with new technologies.
· Leadership
o Guide developers in solution design & problem-solving
o Bring innovation and new ideas to the team
· Excellent communication skills
o Exceptional English, written and verbal communication skills
o Presents oneself clearly and articulately when speaking with an individual or before a group assuring that others fully comprehend the intended message
Skills/Qualifications:
· Strong proficiency with SQL and its variation among popular databases
· Experience with some of the modern relational databases, with a particular focus on SQL Server
· Skilled at optimizing large, complicated SQL statements
· Knowledge of best practices when dealing with relational databases
· Capable of configuring popular database engines and orchestrating clusters as necessary
· SSIS experience
· Ability to plan resource requirements from high-level specifications
· Capable of troubleshooting complex database issues
· Familiar with tools that can aid with profiling server resource usage and optimizing it
· Proficient understanding of code versioning tools such as GIT/SVN
· Experience with C# and .NET would be a bonus
