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, but 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
Qualifications and Required Skillsets
SQL / Database Skills
- 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
- 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.
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.
