Senior Database Developer

Description :

The role requires a balanced and competent technical resource to help design and manage data solutions for a large business critical application.

The ideal candidate is a tech-savvy developer whose primary function is to create and maintain application database components using SQL Server.

The developer will have to design solutions appropriate for the requirements and ensure the rollout of the solution in a structured manner adhering to the established processes.

This is a developer role with a large percentage of SQL based development and programming, and not a DBA role. While DBA skills are of value, the person will not be performing day to day DBA work.

The key expectations are the ability to design and execute database data management solutions for a complex application in a manner that is technically sound, robust, reliable, performant, standards based and secure.

The developer will be part of a large project team and would need to work with Application and Database Architects and Program Managers.

The database technology in use is SQL Server 2016. The following lists the essential job functions :

Building robust, scalable and performant solutions that meet the business requirements. Provide database development assistance in creating and enhancing applications including stored procedures and update scripts.

Ensure database programs meet reliability and performance standards

• Participate in the development, enhancement and ongoing maintenance of SQL server components including tables, procedures, functions and triggers for both OLTP and OLAP models
• Develop, implement and optimize stored procedures and functions using T-SQL. Analyze existing SQL queries for performance improvements.

This includes creating and enhancing views, functions and stored procedures

Working independently in the team with ability to develop and promote code across dev and test environments and ensuring quality code is delivered into test and production

Below are the key responsibilities of the SQL developer :

• Work with the existing project team to help design and develop new database schema objects such as tables, indexes, views, stored procedures, functions, triggers
• Support the existing application database schema with maintaining and optimizing objects such as tables, indexes, views, stored procedures, functions, triggers
• Work with the data architect and the application team on new project initiatives
• Participate in code reviews and provide guidance and supervision that ensures adherence to standards and promotes quality design and programming practices

SQL / Database Skills

• Advanced proficiency in SQL , database design and concepts. Solid understanding of data management including Microsoft SQL Server permissions, recovery, security, monitoring, and data modeling
• Demonstrable proficiency with tuning SQL databases for performance, reliability, and availability. Expert T-SQL development skills including query optimization, stored procedures, views, functions and triggers
• Prior experience in handling Complex SQLs and systems managing large volumes of data
• Strong and thorough knowledge of SQL, the underlying constructs and the ability to write performant SQLs utilizing the features provided by the RDBMS
• the candidate is expected to understand the principles driving Database Architecture and the concepts guiding Software Architecture & Design and Software Development at a conceptual level

Process and Methodologies

• A good understanding of SDLC processes and automated tools, spanning requirements / issue management, defect tracking, source control, build automation, test automation and release management
• Exposure and experience in methodologies such as Agile, SCRUM, Kanban approaches to software development
• Experience with technologies, such as TFS, Github, Confluence, JIRA is a required

Soft skills

• Excellent communication skills
• Ability to work with a diverse set of resources
• Ability to deliver quality solutions under tight timelines

Good to have

Besides the requisite skills in SQL as highlighted above, the following are good to have.

• Exposure to multiple databases Relational Oracle, Postgres, MySQL or any other Non-relational SQL MongoDB, Cassandra, Neo4J
• Reporting Technologies SSRS, PowerBI, Crystal Reports or similar
• Understanding of ETL and exposure to a standard ETL tool
• Big data technologies like Hadoop and Spark
• Cloud services like Amazon AWS and Microsoft Azure

What's in it for you?

• Fortune 500 client, Oil & Gas industry, complex environment, and technology
• Great technical teams on both Authority Partners and client-side
• Genuinely healthy collaboration and work atmosphere strong, friendly relationships, and great work ethic across the board
• This highly corporate environment has a family business feel to it a completely different vibe than what you usually see / expect from corporations
• Support from all roles included in the process

AP Perks :

• Most cutting-edge technologies
• Opportunity to work with people who are at the top of their field
• Great culture and environment
• Competitive remuneration package (We reward excellence)
• Career growth
• Collaborative learning environment
• Mentorship programs
• Professional training

About Authority Partners :

Authority Partners is a leading and global IT services company with over 26 years of experience, serving clients within the financial, healthcare, insurance, mortgage, and technology sectors among many others.

We are committed to building relationships with IT professionals who possess integrity, dedication, teamwork, and the desire to learn and grow with us.

We specialize in placement for long-term contracts and permanent opportunities and helping our consultants achieve their career success.

AP Testimony :

At AP I have always had the privilege to work with people who support each other and share goals and passion for excellence.

I got the opportunity to build my skills through various engagements, from a startup client to one of our largest accounts."

Ena Durmisevic, Program Manager.

If you want to learn more about Authority Partners’ selection and interviewing process, as well as our culture, we invite you to listen to our podcasts and watch our corporate video :

By Zerina Sulejmanovic Terzic, Head of Talent Acquisition Department

Authority Partners is an equal opportunity employer and is committed to providing a workplace that is free from all types of discrimination, as well as from abusive or offensive behavior and harassment.