Database Developer - Sr

eTeam
Lenexa, KS, United States
Full-time
We are sorry. The job offer you are looking for is no longer available.

5 years of database / ETL development experience using SQL Server and SSIS technologies .

Masters Degree in Computer Science (or related field) with 3 years of database / ETL development experience using SQL Server and SSIS technologies .

T-SQL development experience - 6+ years

SSIS development experience - 6+ years

Reporting / data analysis 6+ years

Fuzzy matching and Grouping (must have)

Extensive knowledge of Replication

Data analysis, data mapping, data migration, writing specifications for system interfaces

Optimization of indexes

Optimization of stored procedures

Stored procedure and function scripting as required to support projects / tasks

Database performance tuning

MSSQL Database Administrator experience required +5 years

Oversight of database design and the enforcement of companywide usage of SQL best practices and development standards

Work with other database administrators, developers, technical analysts, architects, and project management teams to refine the application design requirements based on customers business needs

Create ad hoc SQL queries customer reports, executive management reports

Duties / Job Responsibilities :

Analyze, design, develop and maintain ETL / SSIS applications that service internal and external vendor and client systems aligning with the business needs.

Create detailed specification documents based on business requirements.

Develop quick prototypes for business stakeholder verification to use as a foundation for design / development solutions.

Create and execute testing plans and procedures.

Automate processes using software tools and scripts.

Manage system enhancements and upgrades.

Participate in latest technology research applicable to meet new business challenges.

Provide guidance, mentoring, education, and leadership on how to effectively create and support the applications.

Follow best practices for technology and business level technology implementation.

Conduct system architecture reviews to guarantee corporate alignment.

Conduct code level and other systems quality assurance tests and procedures.

Experience with enterprise architecture tools such as MS SQL Server Management Tools, source control, defect tracking, integration, and workflow tools.

6 days ago
Related jobs
Promoted
Outlier
Overland Park, Kansas
Remote

We are seeking experienced software engineers and coders to be part of the artificial intelligence (AI) revolution. If you are an experienced software engineer, computer scientist, programmer, or just great at solving coding challenges (Codeforces, Sphere Online Judge, Leetcode, etc. Join our team i...

Promoted
Follett School Solutions
Overland Park, Kansas

We are a fully-remote software development company that sells subscription-based Software As A Service (SaaS) and we are looking to expedite our growth by adding another developer. Perform code reviews on fellow developer's code commits as they complete features. BS in Software Engineering or simila...

Promoted
Buildertrend
Olathe, Kansas
Remote

The Database Administrator will keep our database up and running smoothly 24/7. Proven working experience as a SQL Server Database administrator, preferably with high volume enterprise applications. Build, manage, and performance tune SQL Server database systems of high performance, availability, an...

Promoted
System One
Lenexa, Kansas

This position consists of a wide variety of responsibilities including discovery/investigation of business rules and code, app design starting with the interaction between you and the UI/UX team, new feature code development using best coding practices and tools, streamlining the implementation of y...

Promoted
Capstone IT Staffing
Overland Park, Kansas

As a Senior Software Engineer, you will be developing, testing, implementing, and maintaining software applications for multiple platforms, bringing innovative, seamless and performant solutions that change lives for our customers. Provide technical mentoring and guidance to less experienced Softwar...

Promoted
Ascend Learning, Inc.
Leawood, Kansas

Senior SQL Server Database Administrator**. Develops database solutions by designing proposed system, defining database physical structure and functional capabilities, security, back-up, and recovery specifications. Be a key member of Database Engineering team. Experience as a Database Architect foc...

Promoted
FlightSafety International
Overland Park, Kansas

Works with fellow software engineers, hardware engineers and management to affect a smoothly integrated system. Provides support to team leaders and project engineers in software requirements, design, and implementation. Evaluates, selects, and applies appropriate engineering techniques and procedur...

Promoted
Advantage Tech
Kansas City, Kansas

Expertise in Data warehousing - data modelling, relational and Dimension modelling, Data quality, data catalog and Data Governance. Minimum of 7+ years of increasingly responsible experience in Data Platforms, Data Engineering, Software Engineering at high impactful and changing environments. Experi...

Promoted
Legion Systems LLC
Kansas City, Kansas

Legion Systems is seeking an experienced Oracle Database Administrator to help the USMC operate their enterprise hybrid cloud application-hosting environment. Provides cluster and data center database administration, operational support and problem resolution. Coordinates troubleshooting and collabo...

Cboe Global Markets, Inc.
Lenexa, Kansas

Our Software Engineers design, develop, deploy, and support market surveillance systems. The candidate must collaborate with other engineers and testers to develop effective software tools implementation for application monitoring, capacity management and stress testing. Automate deployment pipeline...