IndianapolisINRecruiter Since 2001
the smart solution for Indianapolis jobs

Facets Database Analyst

Company: Apex Systems
Location: Indianapolis
Posted on: February 23, 2021

Job Description:

Apex Systems is seeking a candidate to assist with a program. The program leadership has an aggressive set of goals to scale down and decommission legacy systems while expanding the functionality of the strategic platform (Facets) beyond to add best in class features for ease of use by membership and employee staff via Agile processes. Job Function:

  • Work in partnership with existingm cross-functional teams, application owners and developers to secure, tune, upgrade and maintain existing SQL Server databases.
  • Work with Dev teams to review and optimize queries being designed and developed in custom code (Batch/API) for performance.
  • Review current code base as performance testing identifies issues, provide feedback to Dev teams.
  • Continuously look at the way core Facets databases are setup - page lock vs row lock as that has generated performance issues.
  • Assists in development of systems and procedures affecting database management, design and maintenance
  • Support problem resolution; consult and advise in application design and tuning; plan, organize and execute product benchmarks for threshold and functionality
  • Participate in product evaluations, design review session, data requirement meetings and consulting with application development products
  • Performance Tuning
  • Project Delivery
  • Review ongoing and proposed projects to identify opportunities for reuse and process improvement
  • Review technical documentation to verify compliance with client requirements and established architectural standards and guidelines
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Refine and automate regular processes, track issues, and document changes
  • Provide on call support for critical production systems on a rotation basis.
  • Perform scheduled maintenance and support release deployment activities after hours as needed.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. Required Skills:
    • 4+ years of MS SQL Server Administration experience
    • 4+ years of experience with database performance tuning and optimization, using native monitoring and troubleshooting tools
    • 4+ years of experience with backup, restore and recovery models
    • 2+ years of experience with high availability and disaster recovery options for SQL Server
    • 2+ years of experience working with Windows Server and Active Directory
    • Available to provide periodic off hours support for Production implementation events.
    • Performance tuning experience
    • SQL Server MCSA/MCSE certifications
    • Power shell experience
    • Unix/Shell Scripting experience
    • EDI knowledge
    • Experience with globally dispersed teams
    • Network (General TCP/IP, DNS, Firewall & Load Balancer)
    • Mongo DB
    • Kafka EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or - provided by Dice

Keywords: Apex Systems, Indianapolis , Facets Database Analyst, IT / Software / Systems , Indianapolis, Indiana

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Software Engineering Architect
Description: We inspire and enable teams to perform better, together. br br Imagine what you could do here. At Passageways, having big ideas is encouraged they have a way of becoming great products, services, (more...)
Company: Passageways
Location: Indianapolis
Posted on: 02/27/2021

SAP QM Principal Consultant - CSI-IT
Description: SAP QM Principal Consultant - CSI-IT-108- Indianapolis, IN We are looking for SAP QM Principal Consultant for our client in Indianapolis, IN br br Job Title: SAP QM Principal Consultant br br (more...)
Company: Cynet Systems Inc
Location: Indianapolis
Posted on: 02/27/2021

Technical Writer
Description: TeamSoft's client in looking for a Technical Writer for a contract role. br Description: --- Take the lead in writing and maintain records of all development
Company: TeamSoft Des Moines
Location: Indianapolis
Posted on: 02/27/2021

Sr. Full Stack Software Engineer
Description: As an experienced Software Engineer, you will advance our modern, cloud-first fundraising software platform. We use Golang and Angular, practice continuous delivery, and are excited to see the impact (more...)
Company: Onebridge
Location: Indianapolis
Posted on: 02/27/2021

Backend Developer
Description: The nation's leading Web Services and e-Commerce company is currently seeking a Backend Developer to complement their growing team. NIC - Indiana, LLC, our Indianapolis-based subsidiary of the eGovermnet (more...)
Company: NIC Inc
Location: Indianapolis
Posted on: 02/27/2021

.NET Developer
Description: Company Description:myCOI is an early industry-leader in the insurance technology space providing an innovative SaaS solution for tracking, processing, and managing certificates of insurance. Our Purpose (more...)
Company: myCOI
Location: Indianapolis
Posted on: 02/27/2021

Software Automation Tester
Description: Software Automation Tester What you'll do:Testing and quality control of various automation software and integration solutions produced by developers is at the heart of this role along with advocating (more...)
Company: Tangoe
Location: Indianapolis
Posted on: 02/27/2021

Enterprise Software Architect
Description: Title: Enterprise Software Architect Duration: 1yr contract with possibility to extendLocation: Remote Indianapolis, IN OVERVIEWThe Enterprise Software Architect will align business and IT stakeholders (more...)
Company: Brooksource
Location: Indianapolis
Posted on: 02/27/2021

Scrum Master/Project Manager
Description: Location: Indianapolis, IN Description: Our client is currently seeking a Scrum Master/Project
Company: The Judge Group, Inc.
Location: Indianapolis
Posted on: 02/27/2021

Cognos Developer
Description: Title: Cognos DeveloperDuration: 3-month contract possibility of extension Location: 100 remote physical office is located in downtown Indianapolis OVERVIEWOur Fortune 500
Company: Brooksource
Location: Indianapolis
Posted on: 02/27/2021

Log In or Create An Account

Get the latest Indiana jobs by following @recnetIN on Twitter!

Indianapolis RSS job feeds