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, 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 FunctionsThe 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 standardsParticipate in the development, enhancement and ongoing maintenance of SQL server components including tables, procedures, functions and triggers for both OLTP and OLAP modelsDevelop, 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 proceduresWorking 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

ResponsibilitiesBelow 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, triggersSupport the existing application database schema with maintaining and optimizing objects such as tables, indexes, views, stored procedures, functions, triggersWork 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 SkillsetsSQL / Database Skills10+ years working experience with SQL Server 2012, 2014, or 2016 in developing, implementing, and supporting SQL server applicationsAdvanced proficiency in SQL, database design and concepts. Solid understanding of data management including Microsoft SQL Server permissions, recovery, security, monitoring, and data modelingDemonstrable proficiency with tuning SQL databases for performance, reliability, and availability. Expert T-SQL development skills including query optimization, stored procedures, views, functions and triggersPrior experience in handling Complex SQLs and systems managing large volumes of dataStrong and thorough knowledge of SQL, the underlying constructs and the ability to write performant SQLs utilizing the features provided by the RDBMSthe 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 MethodologiesA good understanding of SDLC processes and automated tools, spanning requirements /issue management, defect tracking, source control, build automation, test automation and release managementExposure and experience in methodologies such as Agile, SCRUM, Kanban approaches to software developmentExperience with technologies, such as TFS, Github, Confluence, JIRA is a required

Soft skillsExcellent communication skillsAbility to work with a diverse set of resourcesAbility to deliver quality solutions under tight timelines

Good to haveBesides the requisite skills in SQL as highlighted above, the following are good to have. Exposure to multiple databases Relational – Oracle, Postgres, MySQL or any otherNon-relational SQL – MongoDB, Cassandra, Neo4JReporting Technologies – SSRS, PowerBI, Crystal Reports or similarUnderstanding of ETL and exposure to a standard ETL toolBig data technologies like Hadoop and SparkCloud 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-sideGenuinely healthy collaboration and work atmosphere – strong, friendly relationships, and great work ethic across the boardThis highly corporate environment has a family business feel to it – a completely different vibe than what you usually see/expect from corporationsSupport from all roles included in the process

AP Perks:Most cutting-edge technologiesOpportunity to work with people who are at the top of their fieldGreat culture and environmentCompetitive remuneration package (We reward excellence)Career growthCollaborative learning environmentMentorship programsProfessional 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.

Key Skills

• SQL
• RDBMS