Analyst Database Administrator
7 months ago
Job Description
:POSITION DESCRIPTION (JOB SUMMARY)
The candidate will be a member of a team within Data Management Services (DMS). The primary role on the team will be as a SQL Server Database Administrator supporting various Canadian and US client applications, but the individual may be asked to take on additional duties including: infrastructure support and cross-training on other DBMS platforms.
PRIMARY OBJECTIVES
Resolution of reported service requests, pro-active and reactive performance analysis related to databases Carry out Database migrations, upgrades, patching and evaluation/roll out of new database related tools Troubleshooting, monitoring and diagnose issues with SQL Server Database engine, SSIS, SSRS, SQL codes and highly customized jobs. Adherence to documented standards and procedures while doing database related activities like change management.RELATIONSHIPS
REPORTS TO : Delivery Manager,DMS
SUPERVISES:
EXTERNAL RELATIONSHIPS: Servicing customers, partners
INTERNAL RELATIONSHIPS: Working with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services.
TASKS, DUTIES & RESPONSIBILITIES
Support Areas Database Administrative support of SQL Server versions 2014 – 2022 : Monitoring, maintenance and housekeeping of SQL Server and Databases, SQL Jobs, User Access management and regular client requests. Writing and tuning SQL codes and highly customized jobs. Infrastructure support of SQL Server versions 2014 – 2022 : server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development. BI support of SSIS and SSRS: Deployment, Security, performance tuning, Creating and enforcing Standards & best practices, automate repetitive tasks, designing, troubleshoot and diagnose issues with SSIS, SSRS. Support of application and upgrade database (Database Migration/ upgrade) from existing SQL versions to latest SQL Server versions. Incident Management: Knowledge of Incident management process and participation in a rotational on-call schedule to support off hours production incidents Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises Maintaining up-to-date documentation and procedures for all supported applications and environments. Maintaining 99.99% availability for all production environments. Evaluation of functionality and features with newer versions of the SQL Server DBMS/ database related tools Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues. Monitoring and support of nightly production batch cycles (SQL Jobs and SSIS Packages). Regular review of database maintenance/ support tasks and performance improvement procedures Work Planning/Escalation: Organizing and monitoring personal workload and escalating to manager when issues arise Continuous Improvement: Sharing ideas for process improvement and innovative solutions to known problemsKNOWLEDGE, SKILLS & ATTITUDES
Intermediate Knowledge SQL Server Concepts like SQL Architecture, Indexes, T-SQL skills & DMV. Database Maintenance/ Support tasks and lower-level monitoring using tools like Extended Events, DMV, PerfmonSQL Server Replication , Always-on , AWS , Clustering .Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)Understanding of system tables, stored procedures, functions, triggers & SQL tuning General troubleshooting like assisting clients with various issues related to connectivity, permissions, access , distributed queries issues, suggesting solutions, best practices etc. SQL Server Security , adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts. Desirable to have Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing SQL codes.Hands-on experience with SQL Server installations and patching. PowerShell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them.Some knowledge of data-mapping and logical and physical data modeling.Knowledge of AWS, Specifically, migration to AWS from in premise data centerBasic Database DevOps knowledgeCORE COMPETENCIES
Strong analytical abilities and willingness to handle medium to complex scenarios. Excellent communication skills (both verbal and written) Very high commitment levels and willing to work in any shift timings. Strong organizational skills with the ability to do multi-tasking Detailed oriented, focused approach on handling issues Taking accountability and ownership Sharing information and best practices with team members Drive Knowledge management sessions in expertise skill with teamMINIMUM QUALIFICATIONS & EXPERIENCE REQUIRED
DEGREE/ DEPLOMA IN : BE/ B. Tech /MCA / M. Tech / in Computer Science or related technology.
PRIOR EXPERIENCE: Minimum 4 to 6 years of SQL Server database administration experience handling medium to large databases.
In SQL Server 2014- 2022 running on the Win Server 2016, 2022 operating systemGOOD TO HAVE: Basic knowledge of SSAS, CMD Shell Scripting/ FTP shares, Powershell, VB script and .net/C# would be preferred.
Experience on SQL tools like power designer, DB artisan, Redgate.
CERTIFICATIONS : Microsoft Database certification or AWS certification
Job Category:
IT - Application DevelopmentPosting End Date:
29/04/2024-
Database Administrator
6 months ago
Gurugram, Haryana, India Kyndryl Full timeWho We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The Role -...
-
Database Administrator
3 weeks ago
Gurugram, India Real Time Data Services Full timePosition Overview: We are seeking a skilled Database Administrator with 4-6 years of experience to manage, maintain, and optimize our database systems. The ideal candidate should have strong expertise in MySQL and MongoDB, ensuring high performance, availability, and security of our databases. To apply Please fill below form: RTDS Application Form Key...
-
Database Administrator
3 weeks ago
Gurugram, India Real Time Data Services Full timePosition Overview:We are seeking a skilled Database Administrator with 4-6 years of experience to manage, maintain,and optimize our database systems. The ideal candidate should have strong expertise in MySQL andMongoDB, ensuring high performance, availability, and security of our databases.To apply Please fill below form:RTDS Application FormKey...
-
Database Administrator
3 weeks ago
Gurugram, India Real Time Data Services Full timePosition Overview:We are seeking a skilled Database Administrator with 4-6 years of experience to manage, maintain,and optimize our database systems. The ideal candidate should have strong expertise in MySQL andMongoDB, ensuring high performance, availability, and security of our databases.To apply Please fill below form:RTDS Application FormKey...
-
Database Administrator
3 weeks ago
Gurugram, India People Prime Worldwide Full timeAbout Company : India’s exports (both merchandise and services) are expected to be worth $760 billion fiscal, growing by nearly 90 percent over $676 billion in FY-22. Foreign Trade Policy will likely herald a new era of streamlined processes, robust infrastructure and support for Small and Medium Enterprises ( SMEs) to reinforce India's presence in the...
-
Database Administrator
3 weeks ago
Gurugram, India People Prime Worldwide Full timeAbout Company : India’s exports (both merchandise and services) are expected to be worth $760 billion fiscal, growing by nearly 90 percent over $676 billion in FY-22. Foreign Trade Policy will likely herald a new era of streamlined processes, robust infrastructure and support for Small and Medium Enterprises ( SMEs) to reinforce India's presence in the...
-
Database Administrator
3 weeks ago
Gurugram, India People Prime Worldwide Full timeAbout Company : India’s exports (both merchandise and services) are expected to be worth $760 billion fiscal, growing by nearly 90 percent over $676 billion in FY-22. Foreign Trade Policy will likely herald a new era of streamlined processes, robust infrastructure and support for Small and Medium Enterprises ( SMEs) to reinforce India's presence in the...
-
Database Administrator
3 months ago
Gurugram, India Chiselon Technologies Pvt Ltd Full timeHiring!!!We are Hiring for our Iconic Client!!!!Position: Database AdministratorExperience: 6+ YearsLocation: GurgaonWork Mode: HybridJob OverviewWe are looking for a Senior Database Administrator to join our team. The position is based in Gurgaon and offers a hybrid, full-time employment opportunity. The ideal candidate will have a minimum of 7 years and a...
-
Database Administrator
4 months ago
Gurugram, Haryana, India Saksoft Full time**Designation **:Developer **Job Description**: **Responsibilities**: - 4 - 6 years of hands-on experience as a Database Administrator (DBA) and Developer - Experience working with SQL Server and Azure, including database maintenance, development, and optimization. - Strong understanding of database architecture and design principles - Proficiency in SQL...
-
Senior Database Administrator
2 weeks ago
Gurgaon/Gurugram/Remote, India Lancetech solutions Full timeJob Title : DBA Administrator. Location : REMOTE/Gurugram. Shift timing : 1:30PM to 10:30PM. Mandatory Skills : 7-14 years in database SQL, MySQL, DBA. The ideal candidate will ensure the performance, integrity, and security of our databases and develop and maintain database applications. Key Responsibilities : Database Administration : - Design,...
-
Senior Associate
2 months ago
Gurugram, India Ankura Consulting Group, LLC Full timeJob Description Summary : Are you a self-starter? Do you enjoy supporting globally based teams? Would your friends generally describe you as a night owl? If so, Ankura is looking for a Database Administrator that fits these criteria with the desire to be a critical member of our team. Under minimal supervision, you will work as a member of the Data &...
-
Database Administrator
2 weeks ago
Gurugram, India talent potential consulting Full timeJob Description :- Design, install, configure, and maintain MySQL databases to support AMI applications and services.- Perform database tuning and optimization to ensure high performance, reliability, and scalability.- Ensure optimal database performance by monitoring, diagnosing, and resolving performance bottlenecks.- Analyze and refine complex SQL queries...
-
Database Administrator
6 months ago
Gurugram, Haryana, India Netfolks Consulting Full timeRequirements: - Good exposure on Exadata. - Good in performance tuning on oracle database. - Problem solving attitude. - Exposure to automation using any scripting language. - Provide RCA. - Exposure in banking domain. - Good in RMAN backup and Recovery. - Keen to learn new technologies. - Cloud experience on AWS/OCI would be an added advantage. -...
-
SQL Database Administrator
1 month ago
gurugram, India Publicis resources Full timeInstallation, upgradation, Administration and Maintenance of SQL Server Instances Create Users and assign permissions based on the level of database access the user would need Setup High-Availability as part of Disaster Recovery Strategy for the Databases Troubleshoot various problems that arise in the day-to-day operations and fix the issues Monitoring and...
-
SQL Database Administrator
1 month ago
Gurugram, India Publicis resources Full timeInstallation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in the day-to-day operations and fix the issuesMonitoring and...
-
SQL Database Administrator
1 month ago
Gurugram, India Publicis resources Full timeInstallation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in the day-to-day operations and fix the issuesMonitoring and...
-
SQL Database Administrator
4 weeks ago
Gurugram, India Publicis Groupe Full timeSQL Server/Azure Database Administrator- KEY RESPONSIBILITIESInstallation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in...
-
SQL Database Administrator
4 weeks ago
Gurugram, India Publicis Groupe Full timeSQL Server/Azure Database Administrator- KEY RESPONSIBILITIESInstallation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in...
-
SQL Database Administrator
4 weeks ago
Gurugram, India Publicis Groupe Full timeSQL Server/Azure Database Administrator- KEY RESPONSIBILITIES Installation, upgradation, Administration and Maintenance of SQL Server Instances Create Users and assign permissions based on the level of database access the user would need Setup High-Availability as part of Disaster Recovery Strategy for the Databases Troubleshoot various problems that arise...
-
Database Administrator
7 months ago
Gurugram, Haryana, India Orange Full time**key result / decision areas (outcomes) Install and maintain the performance of database servers. Develop processes for optimizing database security. Set and maintain database standards. Manage database access. Performance tuning of database systems. Diagnose and troubleshoot database errors. Recommend and implement emerging database...
