Data Integration Lead

Data Integration Lead

Hexaware
9-12 years
Not Specified

Job Description


Job Description
Must Have Skills*
70% SQL Developer and 30%Admin

Admin Skills:
  • DB queries,
  • DB theory
  • DB design
  • RDBMS,
  • System Storage, Security and Monitoring.

Developer Skills:
  • SQL design skills,
  • Refactoring skills,
  • Designing Tables and structures,
  • Creating Views, Functions and Procedures.
  • Creating Triggers, Maintaining Data quality and DB security.

Nice To Have Skills
Good to have experiences in MS SQL, NoSQL, Oracle, MongoDB, DB2, Cosmos etc
Job Summary:
(Briefly describe the main objectives and purpose of the job. Why does the job exist What is it expected to accomplish)
This role is for an experienced Database Administrator/Developer who is technically skilled in the full life cycle management of Databases for an organization. The role is not just limited to Administration, but the individual should be highly skilled in development activities too. Following are the expected skillsets towards the requirement.
Admin Skills:
.DB queries,
.DB theory
.DB design
.RDBMS,
.System Storage, Security and Monitoring.
Developer Skills:
.SQL design skills,
.Refactoring skills,
.Designing Tables and structures,
.Creating Views, Functions and Procedures.
.Creating Triggers, Maintaining Data quality and DB security.
The candidate must possess hand-on experience to define, design SQL database for mammoth (higher query defied RDMS) Front End Portals, applications. Good to have experiences in MS SQL, NoSQL, Oracle, MongoDB, DB2, Cosmos etc.
Essential Functions of the Job:
(Identifyand describe essential functions, or primary duties and responsibilities. Assume that the reader does not know the role or function of the job.)
  • Develop a global strategy for EY's Modern Meeting program SQL [DBA]
    • Robust - the tables are logically designed and will scale as the solution grows.
    • Scalable - the candidate should be able to build out the platform to multiple (geo) locations and keep latency low and user experience high.
    • Provide guidance on data that needs to be replicated between SQL nodes. A design needs to be made that will show what needs to be replicated and what doesn't.
  • Provide metrics for monitoring SQL activity
    • Be able to provide training for engineers and ops to look at the metrics - using the tools available, we should be able to track performance and growth data. We need to proactive determine a course of action before it happens with the data we have.
  • Develop custom SQL code to support reporting capabilities such as 'SQL views' and PowerBI which is robust enough where the admin/requestor can pull data.
  • Provide day-to-day support on SQL until end of POC project [DBA]
  • Make sure documentation is available and current [DBA]
  • Develop disaster recovery plan [DBA]
  • Data syncing [DBA] - Create a process where the respective data is copied to MMS database and service now.

Analytical/Decision Making Responsibilities:
(Describe the kind of problems and challenges typically faced, and decisions required to perform the job, as well as recommendations made to supervisors or others. Focus on the nature of existing policies, precedents and procedures used to guide decisions, and the degree to which the incumbent is free to make decisions requiring interpretation and judgment. Provide an example.)
.Proactively anticipates service issues before they occur and able to make recommendations around resolution.
.Proactively monitor and manage Azure related components.
.Sound analytical and problem-solving skills are required to manage multiple technical challenges from multiple services and projects simultaneously
.Evaluate recommendations provided for service improvements, with the ability to identify any gaps or alternate solutions.
.Proactively anticipate service issues before they occur and drive suggested changes to execution.
Supervision Responsibilities:
(Describe the level of supervision received (i.e., the frequency of supervisory contact, degree to which the individual acts independently and on what kinds of issues). Describe the level of supervision of others, if any (i.e., assigning work, reviewing performance, direct or indirect responsibility).
This is an individual contributor role
Other Requirements:
(Describe other functions or expectations of the job such as whether overtime is regularly required (e.g., during busy season), whether there are particular times of the year that vacation may not be taken, whether there is frequent travel, whether there are any physical requirements beyond those expected in a normal office environment or any other miscellaneous things about the job that should be made known.)
.Candidate must be flexible to the demands of the services we provide and any project to which they are assigned.
.The role may require out of office hours work.
Job Requirements:
Education:
(What is the minimum level of education needed/suggested to perform this job)
.A Bachelor's degree in Computer Science or related discipline, or equivalent work experience required
Experience:
(What is minimum number of years needed/suggested to perform this job)
.8 years or more working in Database or related function
Certification Requirements:
(Describe and explain any certifications and/or licenses needed or helpful to perform this job).
.
Note:
This job description is intended as a guide to reflect the principal functions of the job. However, it is not an all-inclusive listing of the required job functions and functions may vary depending on the particular geographic location of the job and/or the manager. Further, the job description is subject to change at the discretion of management.

About Hexaware

Job Source : careers.hexaware.com

Similar Jobs

People Also Considered

Career Advice to Find Better

Simple body text this will replace with orginal content