Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 9th Mar 2021
Detailed Job Description:
Key Roles and responsibilities
· Work as SME for Netezza DBA role.
· Acquire knowledge and detailed understanding on customer’s Database environment.
· Validate Scope of Work and Due Diligence of Data and identify gaps
· Responsible for interacting with internal groups, vendors, and customers to coordinate the timely implementation of Database services
· Work effectively on diverse type of customers from different time zones
· Validate RLS and identify skill gaps
· Gather required and detailed information and develop SMTD with complete understanding of customer Database environment.
· Responsible for giving reverse knowledge transfer to BAU and getting sign-off from customer and internal stakeholders
· Effectively articulate risks and get sign-off on SMTD, Risk Register and other technical / operational documents.
· Propose risk mitigation plan and options. Work with the internal and external eco system to mitigate risks in good time.
· Participate in project planning and prepare MPP.
· Responsible for implementing best practice, hardening, Automation of BAU tasks.
· Knowledge and ability to identify the risks on the customer Database environment & make recommendations of solutions according to the industry best practices relevant for customer landscape.
· Change management in customer end for remote management of Databases and onboarding of Monitoring tools.
· Self-driven and motivated individual who can lead from the front and take end to end ownership of the Netezza Database Process and Technologies for seamless transition and smooth Go Live of services from the perspective of People, Process and Technology.
·
Technical skills:
· Should have minimum 10+ years hands on experience in terms of design, architecting and management of Netezza Databases.
Mandatory Skills (Must Have)
Primary skills:
· In-depth technical knowledge of Netezza Database Administration
· Handling Large database (OLTP) in TB’s
· Proficient with Netezza server Tools
· Netezza Installation & Configuration. Alert configurations.
· Proficient with Netezza Maintenance like backup and recovery, Integrity, and Index maintenance
· Database user and object management
· Should have knowledge on database Patching, Migration on all Netezza server versions
· Performance tuning
· Configure and Maintain high availabilities or DR like Logshipping, Replication, Database Mirroring
· Experience on Automation
· Should have ability to pro-actively identify areas of improvements and works towards a better delivery of the projects
· Excellent communication and inter-personal skills
Secondary Skills at least L2 or L2+ (Good to have)
· Knowledge on PostGresSQL, Oracle, MySQL database management and administration or Open source database management and administration.
· Knowledge on Azure and Open source databases such as PostgreSQL, Informix, MySQL
· Database management ,User administration, performance tuning, migration, patching
· Experience working with Databases on the Cloud (AWS/GCP)
· Knowledge in PowerShell scripting