Job Description:

• Manage Database Team located in multiple locations
• Handle projects driven by both Offshore & Onshore
• Distribute Work and project tasks
• Track projects and daily tasks
• Manage patch deployments and upgrades following best practices and provide capacity planning expertise
• Provide administration of development database environments including UAT, Processing, Development and QA based Oracle RAC database
• Perform security implementation in both OS and Database level of production servers ensuring several standard policies and compliances (HIPAA, SOX, PHI)
• Support the business to provide logistic support to Analytics, Production Engineers, Project Managers and Developers
• Working with a distributed team of IT and DBA resources to collaborate effectively with internal and external stakeholders to ensure that Vertica database platforms are highly available, optimally configured and efficiently managed
• Maintain Production servers and minimize downtime and tuning performance of database instances
• Plan for System change and implement
• Provide support to Business during Release process.
• Perform short- and long-term system/database planning and analysis including capacity planning, storage performance, system performance and database performance
• Daily use of SQL, PL/SQL,T-SQL performance tuningsoftware installation, configuration, upgrade and maintenance activities
• High Availability (HA) and Disaster Recovery (DR) options

Required Knowledge, Skills, and Abilities

• Implementing and maintaining large scale OLTP and OLAP systems in mission critical environments
• Information security standards including database system hardening, identity management and database access controls
• Should have knowledge of MS SQL & Oracle
• Should have knowledge of Linux and Windows OS.
• Should have experience in SQL
• Knowledge of Shell, Perl, bash Scripting language
• Administer custom engineered Oracle ExaDATA based Oracle Database software technologies
• Working knowledge of MS SQL Cluster
• Able to support 24X7 Production environment

PREFERABLE SKILLS

• Knowledge of and demonstrable capability in scripting, experience in writing Python/PowerShell or similar scripts
• Experience with Atlassian suite of tools (Jira, Confluence, Bamboo, Crucible, ITIL)
• Other databases technologies like Vertica.

Knowledge of Cloud

SOFT SKILLS

• Ability to work independently or as part of a team
• Persuasive in both written and verbal communication
• US Healthcare experience would be added value

Education + Experience

• Bachelor’s degree or equivalent degree in CS, IT, software or computer engineering, CIS, or any related field of study
• 10 + years of experience AS DATABASE Administrator in Oracle and MS SQL

Job Description:

• Follow software development best practices and industry standards to deliver a robust system
• Write analytical queries based on business requirements
• Database schema design based on the product requirements
• Database query optimization, maintain ETL workflows and SQL scripts for data transformation and analysis
• Engage and participate in all stages of the Software Development life cycle process:
  • Planning, design, development, testing and deployment.
• Prepare flow diagram and technical documentation
• Work and collaborate independently or in a team

Required Knowledge, Skills, and Abilities

• Well-versed and experienced with at least one of the programming languages (Preferred: Python, JavaScript, etc)
• Strong knowledge of OLTP and OLAP database design, best practices and database architecture with experience in Data Warehouse design and data analysis.
• Must have hands on experience in ETL, data transformation, functions, stored procedures, triggers.
• Strong computing foundation and fundamentals
• Eng to end understanding of Software components and architectural layers - Frontend, Backend, REST APIs, OLTP, OLAP databases etc.
• Strong analytical and problem solving skills and well-versed with fundamental programming concepts and/or data-structures and algorithms
• Familiarity with Linux systems and the command line interface
• Proficient working knowledge of GIT and GIT based development workflows
• Willingness to learn, contribute, lead and grow with us.

PREFERABLE SKILLS

• Knowledge of Power BI, Tableau and any other visualization tools
• Experience with Database administration
• Working knowledge of Docker, containers and cloud-native infrastructure
  • Familiarity with ETL automation tools like Apache Airflow, Pentaho DI, SSIS, etc Familiarity with cloud services and platforms like AWS
• Good command in spoken and written communication (in English)

Education + Experience

• At least 2 years of experience in Software development using relational databases & SQL (PL/SQL, T-SQL is preferred)

Job Description:

The main purpose of the job is to provide support database related issue, monitor, review and train team members to work on advanced database related tasks. Take ownership of the project / assigned task and manage his/her team to deliver quality work on time. He/ She should also be involved in Human Resource Management of their assigned teams. 

Key Responsibility

• Involve in the designing, coding and debugging of the software 
• Improve the performance of existing software 
• Maintain and upgrade the existing software
• Provide first level of support for any database related issues raised by team members
• Mentor & monitor juniors to improve team efficiency
• Conduct regular code review of team members
• Provide training to grow skilled resources. 
• Prepare and train team members a knowledgebase of pattern and practices of programming used in FARRMS applications. 
• Help supervisor to identify training/recruitments needs. 
• Regularly attend team meetings to discuss, brainstorm ideas and put forwards ideas to solve any problems 
• Proactively provide and implement new ideas in the application for better user experience 
• Take ownership of projects for its timely delivery including (but not limited to) planning, estimation, development approach, assignment, reporting etc. 
• Involve in performance evaluation of team members

Required Knowledge, Skills, and Abilities

• Excellent verbal /written communication skills, 
• Documentation skills for processes and procedures. 
• He/ she should be a team player and a leader. 

Education + Experience

• 7 years of related experience with a minimum of bachelor’s degree in Computer Engineering (master’s preferred) or equivalent.
• Should have experience in Database Programming using SQL Server and knowledge of FARRMS database framework.
• Should have worked on large database and are familiar with database optimization will be an advantage. 

Job Description:

The main purpose of the job is to develop, document and test the software to ensure that it meets the need of the clients. It also requires an individual to supervise and oversee the technical aspect of the projects to ensure the optimal software performance. 

• Execute system development and maintenance activities.
• Develop solutions to improvise performance and scalability of systems.
• Involve in the designing, coding, and debugging of the software
• Upgrade and maintain the existing software.
• Support maintains and document software functionality.
• First and foremost, support for any client specific issues.
• Provide first level of support for any Software related issues raised by team members.
• Mentor & monitor juniors to improve team efficiency.
• Conduct regular code review of team members.
• Support and develop skilled software engineers by providing advice, coaching and educational opportunities.
• Prepare and train team members a knowledgebase of pattern and practices of programming used in FARRMS applications.
• Help supervisor to identify training/recruitments needs.
• Regularly attend team meetings to discuss, brainstorm ideas and put forwards ideas to solve any problems
• Proactively provide, design, develop and implement new ideas in the application for better user experience.
• Take ownership of projects for its timely delivery including (but not limited to) planning, estimation, development approach, assignment, reporting etc.
• Involve in performance evaluation of team members

Required Knowledge, Skills, and Abilities

• An expert in SQL Server T-SQL programming language, and be comfortable with large, stored procedures, triggers, and complex joins.
• Should have sound knowledge on PHP and JavaScript.
• Knowledge of DHTMLX framework will be added advantage
• Preference will be given to those who have worked on large database and are familiar with database optimization.

Education + Experience

• Minimum of bachelor’s degree in Computer Engineering or equivalent.  
• More than 6 years of related experience