DB engineer in Pasadena, CA at DISYS

Date Posted: 3/24/2018

Job Snapshot

Job Description

POSITION TITLE: Senior Database Engineer


REPORTS TO: IT Manager, Data Services


WORKS WITH: Business stakeholders and other IT teams, including, but not limited to, Business Systems Analysts, Software Engineers, Quality Assurance, Technical Operations, Project Management, etc...


POSITION OVERVIEW: Under direction of the Director of Software Development, the Senior Database Engineer participates in the detailed analysis, design, construction, documentation, and administration of database solutions for various applications.


HOURS: Full Time (generally 40 hours, Monday – Friday)


POSITIONS SUPERVISED: None


PRIMARY DUTIES/RESPONSIBILITIES/EXPECTATIONS:


Database Design and Development

  • Reviews business requirements and technical design documents to develop effective database solutions
  • Logical and Physical Data Modeling for the Green Dot internal and external facing applications using database normalization and de-normalization methods.
  • Developing, documenting and performance tuning of effective data access routines such as stored procedures, views, triggers and functions
  • Developing effective heavy duty data solutions for Database Archiving, Data Conversion and Batch Data interface using SQL Server Integration Services (SSIS)
  • Provide technical leadership for large-scale database projects

Database Management

  • Installation and configuration of SQL Server in database servers in both stand alone and clustering environments.
  • Monitoring and Managing System Performance, Security  and Capacity, taking Proactive actions to increase capacity to meet demand by upgrading hardware including disk, memory and processor
  • Management of the database environment by defining database maintenance tasks, such as backup & restore, indexing, statistics, alerts and notification for database servers.
  • Maintaining documentation related to database server configuration and database change management.
  • Providing User and Develop support for data needs.

OTHER

  • Works on project deliverables while supporting day-to-day production activities.
  • Enforces established documentation guidelines and best practices.
  • Maintains a high degree of business functional knowledge and current automated technologies and tools.
  • Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information, including Protected Consumer Information (PCI) and Protected Health Information (PHI).
  • Adheres to all Company Health and Safety policies and procedures.
  • Administers duties as defined by the Green Dot performance review plan within the required deadlines.
  • Other duties as assigned by supervisor.

QUALIFICATIONS:


REQUIRED

  • A minimum of 7 years or more of hands-on experience with MS SQL Server Database design, development and administration
  • A thorough understanding of relational databases and SQL
  • Experience with MS SQL Server 2005 and 2000 environments with some emphasis in Database Administration, including management tools.
  • Advanced knowledge of SQL query development using MS SQL-Server 2005
  • Strong Experience in SQL Performance Tuning using various performance matrix gathering techniques.
  • Strong Experience in SSIS and heavy duty SQL Development using SQL Server internal database metadata structures, XML and Encryption
  • Experience with database communication mechanisms: .NET, ODBC and TCP/IP
  • Experience in code migration, database change management and data management through the various stages of the development life cycle
  • Understanding of logical and physical modeling concepts
  • Experience with the MS SQL Clustering architecture
  • Excellent communication, interpersonal and organizational skills
  • Ability to prioritize, meet deadlines and to work well under pressure
  • Must enjoy working in a fast-paced teamwork environment and dealing with a variety of people
  • Will work with both minimal supervision and in a collaborative team environment
  • BS degree in Information Technology/Computer Science or equivalent work experience

ADDITIONAL SKILLS DESIRED (all of these would be pluses, but none is absolutely required)

  • Banking and/or credit card systems (stored value systems) experience.
  • Knowledge of new database technologies a plus
  • Experience in architecture and configuration of MS SQL database mirroring, partitioning, Service Broker and Notification Services
  • Experience in Microsoft Operating System – Windows Server 2003
  • Experience in SQL Server 2008
  • Microsoft SQL Certification will be a plus.

Job Requirements

Digital Intelligence Systems, LLC. is an Equal Opportunity Employer, M/F/D/V. We do not discriminate against any employee or applicant because they inquired about, discussed, or disclosed compensation. Email recruitinghelp @ disys.com to contact us if you are an individual with a disability and require accommodation in the application process.Digital Intelligence Systems, LLC. is an Equal Opportunity Employer, M/F/D/V. We do not discriminate against any employee or applicant because they inquired about, discussed, or disclosed compensation. Email recruitinghelp @ disys.com to contact us if you are an individual with a disability and require accommodation in the application process.