Senior SQL Admin/Developer
- 3 Minds ESolutions
- 5 - 15 Years
- Amritsar
- 5 years ago
- Email to a friend
- Report this job
Job Description
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.
Essential Functions of the Job:
(Identify and 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 EYs Modern Meeting program SQL [DBA]
o Robust the tables are logically designed and will scale as the solution grows.
o Scalable the candidate should be able to build out the platform to multiple (geo) locations and keep latency low and user experience high.
o 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 doesnt.
Provide metrics for monitoring SQL activity
o 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.
(Identify and 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 EYs Modern Meeting program SQL [DBA]
o Robust the tables are logically designed and will scale as the solution grows.
o Scalable the candidate should be able to build out the platform to multiple (geo) locations and keep latency low and user experience high.
o 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 doesnt.
Provide metrics for monitoring SQL activity
o 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.
Employement Category:
Employement Type: Full timeIndustry: Full timeFunctional Area: ITRole Category: ITRole/Responsibilies: Senior SQL Admin/DeveloperContact Details:
Company: 3 Minds ESolutionsLocation(s): Amritsar+ View Contact
Fraud Alert to job seekers!
₹ Not Specified
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in