Job Description *
Job Title:
Sql Database / Netezza DBA
Job Education requirement:
10 yrs. of related IT experience. Bachelor's Degree at College of Engineering, Information Technology, Computer Science or equivalent work experience.
Expertise in multiple computer languages, database utilities and development procedures and familiarity with emerging technologies. Candidate must possess an in-depth knowledge of complex technologies, tools, methodologies, the enterprise architecture and industry.
He/She must also have a strong understanding of the relationship between information technology, business practices, consumer markets and industry and be able to apply that knowledge to support the needs of critical systems and projects.
Basic Qualifications for Consideration:
Strong expertise in MS SQL database administration
10 years experience on SQL Database Support, design and development.
Work with the DevOps team to develop application store procedures and setup data scenarios in Dev environments to do performance testing of the application.
Support and resolve all the issues related to high availability group and replication from test to production environments.
Query tuning and a sound understanding of access plans and optimization techniques
Supporting application developers and architects in a consulting role
Monitor and optimize the performance of application databases to meet performance and service level agreements, including index analysis and optimization
Participate in allocated DBA tasks, e.g. SQL Service pack upgrades, installations, backup and recovery, tuning, performance monitoring, day-to-day support.
Analyze the high volume tables in production and provide strategies of implementing table partitioning of these tables to production.
Troubleshoot and resolve Production incidents and participate in bridge calls in coordination with application support team in meeting the SLAs.
Possess a knowledge of security and compliance and be aware of security standards.
Support the Application build team in their analysis of performance of application, deployment failures and high availability group in development and test environments.
Perform database deployments and post deployment monitoring.
Participate in development of databases and SSIS packages to meet requirements of new initiatives. Provide advice and guidance on database technology for new business systems.
Manage ongoing initiatives, including server and system upgrades and maintain currency
Hands on exp with MS SQL 2019 on Windows
- Experienced with Replication, Performance tuning, Partitioning, High Availability, Disaster Recovery (backup/restore), Import/exports, building up DB from scratch, DB upgrades
Good communication skills both written and verbal
Job Description Netezza :
Responsible for the design, development, installation and performance of Netezza appliances.
Good understanding on Netezza appliance support, monitoring, performance, and documentation of all Netezza databases ( NPS and MAKO ).
- Able to perform day to day tasks that include : User/Group/Permissions maintenance; Work Load Management; Database/Schema/Table design and maintenance; monitoring and performance; installs and upgrades of all related appliance software; collaboration with IBM Netezza support.
- The Netezza DBA will support primarily a Netezza appliance environment that will include configuration, administration and maintenance of business-critical 24x7 non-production and production environments.
- Perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance on Netezza systems.
- Recommend and implement a detailed security design for the appliance to meet security and application needs.
Preferred Skills, Experience, and Education:
- Experience with server virtualization including Hyper-V and VMWare. Must understand the concepts of server virtualization.
- Experience in the Banking and/or Financial Services Industry
- Excellent skills in performance monitoring, tuning, space and size management
- Experience in replication, partitioning, disaster recovery and high availability solutions.
- Experience on SSIS, SSRS and SSAS.
- Experience with database migrations.
- Broad experience in clustering high availability, fault tolerant systems, SAN
- Experience in defining Database Server Security, User Creation and Right Permission
- Should be competent with Windows Clustering
- Understand the deployment process and provide recommendation on improving the process.
- Experience with Splunk
- Experience with ServiceNow
- Experience with Power shell
- Experience with Database and storage Encryption technologies (Data in motion and at rest)
V 0.0.1