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.
Key Job Functions 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
Responsibilities 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
10+ years working experience with SQL Server 2012, 2014, or 2016 in developing, implementing, and supporting SQL server applications
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
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:
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.