Lead Software Engineer

Company: Horizontal Talent
Location: Schaumburg
Posted on: June 13, 2022

Job Description:

Description:

• 
  
• We are seeking qualified Database Engineer / Administrator is responsible for independently analyzing database performance characteristics and collaboratively changing the database design to improve performance and resource utilization.
  
  
  Duties and responsibilities
  
  
  • 
    
  • Administers, manages, and monitors all systems, including databases, in development, test, stage and production environments.
    
  • Design and implementation of Azure Postgres databases, high-availability solutions, replication, encryption, and disaster recovery solutions.
    
  • Data Partitioning, Purging and Archiving solutions in the Azure PostgreSQL ecosystem.
    
  • Azure CLI and/or PowerShell.
    
  • Writing PostgresSQL, including stored procedures, functions, views, and triggers.
    
  • Query analysis and troubleshooting Leadership responsibilities.
    
  • Provide technical leadership through example, develop innovation, strategies, processes, and best practices.
    
  • Monitor database performance, implement changes, and apply new patches and versions when required.
    
  • Manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems.
    
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
    
  • 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
    
  • Perform scheduled maintenance and support release deployment activities after hours.
    
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
    
  • Own and manage uptime and performance SLAs.
    
  • Ability to work well with team globally specifically in India.
    
  • Work with Development and QA team, guide developers on following best coding practices to write optimal & efficient code.
    
    
    Experience:
    
    
    • 
      
    • 5+ years in database tuning and project support, database server upgrades and migrations, writing and troubleshooting database stored procedures.
      
    • In-depth knowledge of security best practices including database encryption, column level encryption, SSL/TLS connection encryption, and service specific account permissions.
      
    • Experience with Azure databases specifically Azure Postgres.
      
    • Good understanding of DevOps and the role of database administration teams in DevOps.
      
    • Experience performing database deployments (CI/CD)
      
    • Advanced knowledge of performance tuning and administration, query analysis, performance monitoring and tuning, and maintenance routines
      
    • Experience with data warehouse and reporting technologies (specifically Power Bi) a plus.
      
    • Background in automating processes
      
    • Experience with creating and maintaining database infrastructure.
      
    • Experience interacting with customers on an as needed basis.
      
      
      Education:
      
      
      • 
        
      • Minimum of an undergraduate degree in Business, Engineering, or other related field; or a combination of commensurate experience and education.
        
        
        Projects the candidate will be working on:
        
        
        • 
          
        • Curo is chartered with transforming care delivery by focusing on the member and leveraging deep clinical expertise, breakthrough technology, and advanced analytics and AI/ML to deliver the right insights to the right clinician at the right time with a focus on leveraging and productizing internal technologies, solutions and components across the enterprise to provide a market-leading solution for Utilization Management, Prior Authorization, Case & Disease Management and Concurrent Review.
          
          
          Ideal Background:
          
          
          • 
            
          • Experience as a Postgres DBA in a cloud environment
            
          • Performance Tuning experience with Postgres in a cloud environment
            
          • Experience in the healthcare industry
            
          • Good communication skills.
            
            
            Experience:
            
            
            • 
              
            • Good communication skills, Good understanding of how applications and databases interact and need to be tuned. Good understanding of how the data and the business interact
              
              
              Top Requirements:
              
              
              • 
                
              • Experience as a Postgres DBA in a cloud environment 5+ years
                
              • Performance Tuning experience with Postgres in a cloud environment 5+ years
                
              • Good communication skills
                
                
                Team and Team size:
                
                
                • 
                  
                • The Database team consists of myself as manager, 1 Lead, 1 onshore powerbi developer, 1 offshore database developer/powerbi.
                  
                • We will be adding one more offshore database developer.
                  
                • The DevOps Team also contains 2 cloud engineers.
                  
                • We have 3 developer Agile teams onshore and 4 offshore and are quickly expanding.
                  

Keywords: Horizontal Talent, Schaumburg , Lead Software Engineer, IT / Software / Systems , Schaumburg, Illinois