Consultant - Database Administration Job

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

We are looking forward to hire Database Administration Professionals in the following areas :

Job Description:

JOB SUMMARY

The Database Administrator will provide technical and functional support for Ontellus installations of databases including, but not limited to, Microsoft SQL Server (MSSQL) 2008 and above. Position will also assist in the managing of the design, configuration, implementation, and maintenance of MSSQL databases, application design and implementation, performance tuning, data migration, and other areas of database administration.

JOB RESPONSIBILITIES

Responsible for primary support of third-party systems including

• DBA support of production, test and development environments and reporting processes. 
• Administer lead activity for database security, database backups/recovery
• and perform database monitoring, analysis and optimization of all database environments. 
• Assist end user/s with reporting requirements, documentation for queries, reporting and database design.
• Write complex queries, functions, stored procedures and triggers.
• Develop and document technical specifications for third party systems implementation and reporting. 
• Design, plan and implement assigned database environments.
• Properly size and configure databases and their associated tables.
• Provide production support in a 24/7 environment. 
• Coordinate, administer, and perform installation, configuration, troubleshooting and maintenance of assigned database environments. 
• Create and maintain database standards, policies, and procedures, change management standards and policies and ensuring consistency between these and the environments. Formulate recommendation improvements in these areas.
• Responsible for the implementation and support of security measures and products, including activities such as database hardening, vulnerability assessment and patch management.
• Assist in the troubleshooting and resolution of complicated issues within the applications, software/hardware in database environments.
• Evaluate, recommend, and use software tools to monitor and manage database health and performance.
• Plan, coordinate, configure and implement assigned database application patches and upgrades.
• Define and maintain capacity plans, disaster recovery plans and facilities for the database environments.
• Train and mentor other team members through knowledge transfer. Monitor database environments for proper operation within established performance and availability expectations.
• Work with technical analyst to properly size and configure servers for databases and application servers.
• Responsible for advanced configuration of database environments for database level backup/restore technologies and troubleshooting configuration problems.
• Maintain current knowledge of trends and future direction in technology as it relates to area of responsibility.
• Assist with justifications for operating and capital budgets. Prepare and present technical reports and feasibility studies.
• Develop strategic technical implementation plans and work plans for technical teams.
• Regular time and attendance.
• Other duties as assigned.

Job Requirements

• At least 5 years experience as a database administrator in a production environment is required.
• Disaster Recovery/ Business Continuity plans and implementation experience using a remote environment is required.
• Previous experience working in a team environment is required.
• Bachelor’s degree from an accredited institution in Computer Science or related area is required, OR significant work-related experience in all job requirements for this position may be considered in lieu of degree requirement.
• Computer skills required: MS SQL 2008+, SSRS, SSIS, VSDT
• Proficient with Microsoft Office Suite to include Word, Excel, and Outlook
• Outstanding organizational and time management skills
• Excellent communication skills and the ability to communicate with tact and diplomacy
• Attention to detail and the ability to concentrate for extended periods of time.
• Excellent time and attendance
• Ability to work in a team environment
• Self-motivation

COMPETENCIES

In order to perform the job successfully, an individual should also demonstrate the following competencies:

• PROBLEM SOLVING - identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in-group problem solving situations; uses reason even when dealing with emotional topics.
• TEAMWORK - Balances team and individual responsibilities; exhibits objectivity and openness to other's views; gives and welcomes feedback; contributes to building a positive team spirit; puts success of team above own interests; able to build morale and group commitments to goals and objectives; supports everyone's efforts to succeed.
• QUALITY MANAGEMENT - Looks for ways to improve and promote quality. Demonstrates accuracy and thoroughness.
• ADAPTABILITY - Adapts to changes in the work environment; manages competing demands; changes approach or method to best fit the situation; able to deal with frequent change, delays or unexpected events.
• ATTENDANCE/PUNCTUALITY - Is consistently at work and on time; ensures work responsibilities are covered when absent; arrives at meetings and appointments on time.
• ORGANIZATIONAL SUPPORT - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values; Benefits organization through outside activities; Supports affirmative action and respects diversity.
• STRATEGIC THINKING - Develops strategies to achieve organizational goals; Understands organization's strengths & weaknesses; Identifies external threats and opportunities; Adapts strategy to changing conditions.

Access to Protected Health Information (PHI)

• This position requires the employee to handle PHI for duties related to all areas of individual medical records, invoices and other protected information whether written or electronic.

Access to the PHI Includes:

• Access to the company’s operating system and any other sources necessary to process records requests.
• Policies and Procedures will be strictly adhered to make sure PHI is protected as required by the HIPAA Privacy Rule.  Associate will be required to adhere to and acknowledge client policies relating to PHI and HIPAA.

Physical Demands & Work Environment

The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions:

• Must possess mobility to work in a standard office setting and use standard office equipment, including a computer and telephone.
• Requires vision to read printed materials and a computer screen and hearing and speech to communicate in person and over the telephone.
• Finger dexterity is needed to access, enter and retrieve data using a computer keyboard and to operate standard office equipment.
• Positions in this classification must sit or stand for long periods at a time.
• Position also requires the ability to reach and grasp.
• Office environment with moderate noise levels and controlled temperatures
• Ability to lift/carry 10-15 lbs. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

General Sign Off:

• The employee is expected to adhere to all Company policies and to act as a role model in the adherence to said policies.

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture