SQL Server DBA in Carrollton, TX at Vaco

Date Posted: 3/16/2020

Job Snapshot

Job Description

Job Summary:

Applies hardware engineering and software design theories and principles in researching, designing, and developing database schemas, programming stored procedures, and developing and monitoring standard database practices.

Specifically, this position will perform support activities responsible for performing the tasks, executing established, standard methods and processes to ensure Fairway production application systems are on line and fully operational.

Dimensions of Position:

  • Participates in Agile software development projects to design, code, and test database schemas and stored procedures to deliver quality services promptly.
  • Works closely with out IT Operations DBAs to implement standard procedures for proper use of database systems.
  • Translates user stories to tasks relating to process and data requirements.
  • Designs applications technical infrastructure, such as specific databases, programming languages, utilities, and testing approaches.
  • Constructs program flow charts to describe the processing of data and development of precise steps and processing logic across all platforms.
  • Provides broad understanding of platforms and applications across multiple technologies.
  • Execution and performance of production support tasks
  • Ensure all support tasks conform to established standards, this includes incident management, communications, IT compliance and risk management
  • Ensure performance meets or exceeds business user/customer SLA and expectations

  • Required Education/Experience:

    • BS Degree in Computer Science or equivalent and at least 5-8 years work experience in all phases of development and supporting information systems and technologies and associated methodologies
    • Agile development frameworks: Scrum and Kanban
    • 7 + years of development experience using SSMS, SSRS, and SSIS.
    • 7 + years of SQL and other database technologies (SQL Server or similar SQL DB systems, No-SQL systems such as MongoDB or Cassandra)
    • Experience with DevOps and CI/CD technologies, such as JIRA, Confluence, Crucible, BitBucket (or other Git server), and Jenkins
    • Strong Customer and Interpersonal Skills
    • Experience estimating timelines and requirement discovery focused on web and a service Oriented Architecture environment
    • Excellent computer platform skills including Microsoft and Linux workstation and server environments
    • Demonstrable working knowledge of application design, testing, application development, query and database tools, and audit control
    • Demonstrable working knowledge of various application software technology platforms; e.g. Client Server, Web, n_tier, SOA, and supporting programming languages
    • Demonstrated understanding of information systems infrastructure, networks, network components, and topologies
    • Maintenance of existing utility programs and design and development of new utility programs
    • Creation and updating application program and system documentation
    • Strong analytical and problem solving skills.
    • Excellent verbal/written communication skills with both business and technology staff
    • Self-motivated and detail-oriented
    • Ability to manage concurrent tasks
    • Experience in the Mortgage Banking industry is highly preferred.
    • Ability to discuss complex business/technology issues with business users/customers
    • Relationship Management including relationship building with business liaisons and internal partners
    • Other Helpful Knowledge:
      Technical Documentation Methods and Procedures
      Project Management Methodologies especially Scrum and Kanban, Certification helpful but not required.
    • Conducts code reviews and identifies appropriate issues

    • Performs complex and urgent maintenance and problem resolution on software applications involving multiple applications/interfaces

    • Monitor Support Queues Tickets & Server System Metrics for Outages and/or Performance Concerns.

    • This position also requires working with the PM/BA team to gather requirements for system changes/enhancements and migration of these enhancements into Test/Production environments