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