Senior Database DeveloperTechnical
Carlsbad, CA
Job Description

The Database Developer will work closely with members from Software Development, Business Analysis and Quality Assurance Groups in a cross-functional Scrum Team environment. This is a “hands-on” position that requires dedication and diligence. The platform is currently on Microsoft SQL Server 2008 & 2008 R2.

ESSENTIAL DUTIES AND RESPONSIBILITIES:
-Propose design, test, and implement database triggers, stored procedures, T-SQL scripts, and packages.
-Propose database design and development requirements for Software Engineering Projects.
-Assist in development of DEV, QA and operational databases.
-Perform data management tasks as required, loading, editing, restoring and archiving data.
-Propose design and maintain data feed infrastructure.
-Propose design and develop reports.
-Work with Database Architect and Applications Developers to understand business application change requirements and goals and assist in the development of scalable, available, and high performance schema changes in the databases.
-Document systems and processes.
-Troubleshoot production problems and work with other team members to identify and address issues.
-Improve incident and change management processes for agile development environment.
-Handle ad-hoc data requests. Handle back-end data updates to support business users with their operations.
-Provide technical leadership to the team responsible for MNet’s ETL functions for importing customer data as well as populating our data warehouse

REQUIRED SKILLS & EXPERIENCE:
-Knowledge of database development methodologies.
-Knowledge of relational databases, database architecture, schema design, and SQL as well as emerging technologies such as NoSQL.
-Programming or scripting language in addition to T-SQL (Powershell, C#, etc).
-Knowledge of database security concepts, including access, and encryption.
-Good understanding of database synchronization, failover, and recovery.
-Experience with SSIS & SSRS development.
-Experience with conceptual, logical, physical, dimensional and entity data modeling, database design, development and maintenance of data models.
-Experience in developing and maintaining a data warehouse for use with BI tools.
-Experience evaluating, implementing and utilizing 3rd party tools for ETL processing and integrating those tools with other systems
-Fluency with Microsoft SQL Server 2008 r2 Development Studio, SQL Management Objects, Query Analyzer,
-Profiler, Performance Monitor, and other SQL Server management tools.
-5+ years of experience in Database design and development.
-5+ years of experience in T-SQL.
-5+ years of experience in database modeling and design.
-2+ years of technical team leadership

DESIRED:
-Technical foundation and in-depth knowledge of enterprise applications.
-Understanding of Agile development methodology (Agile and Scrum).
-Experience with Database performance monitoring tools and processes
-Experience in Virtual Environments (VMWare)
-Experience in Predictive Analytics

EDUCATION: Bachelor’s Degree in Computer Science or related field.

This job description is not intended to be all inclusive. The candidate hired will also perform other reasonable related business duties as assigned by supervisor. The company reserves the right to revise or change job duties as needed. This job description does not constitute a written or implied contract of employment.

How to Apply
posted 3 weeks ago
Check out MaintenanceNet, Inc.’s Company Culture!