Senior SQL Server Database Developer

Genesis10 is currently seeking a Sr. SQL Database Developer with our client in the financial services industry. You can work from Plano, TX or Portland, OR. This is a for this full time, permanent job opportunity. Description : The Senior SQL Server Database Developer is the enterprise expert for designing, developing, and optimizing data processing systems and pipelines used to populate data into transactional databases, data warehouses, data marts, or other data repositories. A Senior SQL Server Database Developer builds systems to create and optimize data sets and data systems for operating applications, performing analysis, or identifying business or technology issues. You will be responsible for operational support and incident / problem management, from creating logging instrumentation to analysis and process improvements. They also coordinate with other IT teams to configure and implement security, monitoring, tooling, and related capabilities as they apply to their assigned systems. You will report to the Associate Vice President of Corporate Services Technology. Responsibilities : Use Agile practices to elicit and refine requirements through an iterative process of planning, defining acceptance criteria, prioritizing, developing and delivering enterprise data asset solutions in collaboration with business intelligence teams, our users, or other IT teams Develop, configure, customize and manage integration tools, databases, warehouses and analytical systems with the use of data related software Design, build, and deploy data extraction, transformation, and loading processes and pipelines from various sources including databases, APIs, and data files Develop and deploy structured, semi-structured, and unstructured data storage models such as data vault or dimensional modeling on a variety of platforms Coordinate security, application monitoring, development tooling, and related capabilities with responsible teams Provide operational support and incident management for data pipelines and data flows, including proactively updating internal clients and relevant parties on status changes and issues encountered Author and maintain accurate and up-to-date documentation for processes, procedures, and technical designs Train junior data and business intelligence personnel across the company, including developing material, mentoring, and guiding junior personnel on their technical skill growth Requirements : 15+ years' experience developing data-related solutions and software 10+ years of experience working with relational databases and applying it in various applications, including within the Microsoft Azure platform 4+ years of experience with multiple cloud technologies in the Microsoft Stack (Azure IaaS and PaaS) along with familiarity with alternative cloud technologies 4+ years of experience designing and development on-premises and cloud-based (Azure) infrastructure and platform components 4+ years of hands-on development and deployment experience with Azure cloud using .NET, T-SQL, Azure SQL, Azure Storage, Azure Data Factory, Cosmos DB, GitHub, Azure DevOps, and CI / CD pipelines Advanced knowledge of Extract / Transform / Load (ETL) and / or Extract / Load / Transform (ELT) tools, including both batch and real-time data transmission applications such as SSIS, Informatica, Kafka, Spark, MuleSoft, or equivalent software Advanced knowledge of database technologies such as Microsoft SQL Server, Oracle, or NoSQL databases Advanced knowledge of multiple programming languages, such as C#, Java, Python, SQL, Scala, or similar Advanced knowledge of IT infrastructure standards and tools, such as application performance monitoring, IT service management, or DevOps software Bachelor's degree in Computer Science, Information Technology, or other relevant field Compensation : Salary range from 125K to 165K plus potential bonus; benefits package will be shared through the interview process. W2 Status : Only candidates available and ready to work directly as Genesis10 employees will be considered for this position. If you have the described qualifications and are interested in this exciting opportunity, please apply! Genesis10 – Contract & Perm / Direct Hire Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals. For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10 : Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years. The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years. Access to an experienced, caring recruiting team (more than 7 years of experience, on average.) Behavioral Health Platform Medical, Dental, Vision Health Savings Account Voluntary Hospital Indemnity (Critical Illness & Accident) Voluntary Term Life Insurance 401K Sick Pay (for applicable states / municipalities) Commuter Benefits (Dallas, NYC, SF) Remote opportunities available For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website. Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. #DIG10-DA