SPECTRAFORCE
Database Developer
Job Tittle: Database DeveloperDuration: 12 MonthsLocation: Denver, CO / Austin/ DFW, TX / Phoenix, AZ (Hybrid)
Description:The Mid-Level Database Developer will play a key role in organizing and driving work on a new project team and across the larger Compliance and Legal Service Technology portfolio. Core responsibilities include the delivery of functionality while closely working with the development team to ensure implementations meet all technology standards. This role will also be responsible for designing and overseeing coding standards and code reviews while interfacing closely with key stakeholders. 
Responsibilities:As a Mid-Level Database Developer, you will collaborate closely with the technology leads to drive project and database strategy as well as on-time delivery of solutions. Will design, implement and support data warehousing projects, implements business rules via stored procedures, middleware or other technologies and defines user interfaces and functional specifications. Responsible for verifying accuracy of data and maintaining and supporting the data warehouse. Will plan and conduct data warehouse unit system tests, monitors and takes corrective action as needed. Will build and maintain data warehouse databases, designs, codes, tests and implements complex programs and scripts. Coordinates with other IT departments to ensure the implementation and monitoring of data warehouses. Must have prior database design and development experience, strong experience with a data warehouse and an understanding of ISO standards and impacts on data interoperability. Must be detail-oriented, well organized, be a problem-solver with excellent communication skills (both verbal and written).
What you’re good at:Leverage your experience with process, data analysis, systems analysis, process architectures, and systems analysis methodologies which include Agile and Agile Scrum to execute on the following:Develop and implement custom PL/SQL solutions to meet complex business needsExperience with complex SQL queries, embedded hints, performance tuning, and stored proceduresChampion an Agile development methodologyUtilize exceptional interpersonal skills including teamwork, facilitation, communication, documentation, and negotiation to complete work on-time and exceed customer expectations Utilize planning and organizational skills to document and share knowledge with peers to continue building cross-functional expertiseParticipate in and perform peer reviews to ensure high-quality releasesExposure to the Atlassian toolset (Jira, Confluence, Zephyr, Bitbucket, etc) 
Additional Details:BA/BS or higher degree, preferably in an analytical or technical discipline 3-5 years of related experience, with a focus on SQL, data integration, and system design. Experience coding and/ or interfacing with multiple technology stacks simultaneously 3+ years of experience using Agile/SCRUM Experience working in large scale Agile environment spanning multiple Scrum teams and time zones highly desired Excellent written/verbal communication skills Familiarity with the financial services domain or a strong desire to learn about the industry Exceptional interpersonal, problem-solving, prioritization, organization, and decision-making skills Ability to apply innovative technology to solutions that would benefit our clients Ability to continually build relationships with users to increase trust Drive to constantly learn new technology and build domain knowledge Display intellectual curiosity and integrity Preferred: Data migration planning and coordination SQL Server SSIS packages Microsoft SQL Server 2012, 2016, 2019 PowerShell scripting experience is beneficial Control-M as a nice to have Experience with BPM products is preferred Adept at communicating complex technical concepts to non-technical audience 
Primary functions: First, we need someone who can develop a new database from scratch (develop, not administer). Second, we need someone who can work with the existing data to migrate it out of Oracle/SQL to the new database(s). Database development in SQL - will need to create table, views, procedures. nothing databased administrator - don't own infrastructure Working in the data layer of full stack team Must be able to interact with other team members well Will be coordinating with front end devs, api devs, product groups, analysts. Tech role with lots of human interaction Comfortable working in Agile/Scrum
Denver, CO