Our Financial Services client is seeking a Netezza Systems Administrator/DBA to be responsible for the administration of core systems as well as monitoring and repair of high performance computing systems.
Ensures consistent and reliable operation including enterprise servers and network infrastructure.
Managing the entire Netezza footprint of 50+ racks from an infrastructure perspective (hardware/software/network/storage/OS), pre-empt, circumvent and recover from infrastructure issues.
Perform backup and restore activities, database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance on Netezza appliance platform
Use the NzAdmin/NZMigrate tool for typical administrative tasks, including Genstats, Groom, and manage Development to Production environments
Works closely with Developers, Testers, Architects, Business Analysts and other IT staff to implement System and Database Administration standards, policies, methods, and procedures building consensus with all parties.
Assist application development teams with planning and implementing database changes as well as query/job optimization, Database related-releases/upgrades/dbmod.
Work closely with IBM support to manage hardware/software failures, appliance upgrades and install patches
Troubleshoots database problems, including slow running queries.
Participate in after-hours on-call duties as requested, manage workload via prioritization and Leankit, document discovered procedures on SharePoint,
Apply Automation, Metrics, Tooling and Best Practices as required.
Develop Big Data integration and data warehouse best practices.
Deliver measurement and improvement of all aspects of the availability of infrastructure services to match/exceed SLA's.
Monitors service component capacity and initiates actions to resolve any shortfalls according to agreed procedures. Applies techniques to modify demand for a particular resource or service.
System engineering and administration experience in a Netezza appliance environment with substantial knowledge of Unix/Infrastructure including Servers, Network, SAN technologies, I/O subsystems.
Linux system administration including troubleshooting, configuration, networking, server administration/management, security, monitoring, tuning, capacity planning, backup/recovery, service pack/hot fix/patch install, vendor support liaison, coordination with technical staff at all levels.
Must have strong programming/scripting languages such as Perl, Python, Bash or standard development tools
Infrastructure domain knowledge: DNS, NFS, TCP/IP, Clustering/High Availability. Under-the-hood Kernel insight methodologies: tcpdump, strace and system call tracers.
5+ years of experience in a Netezza environment with at least 2+ years as a DBA.
3+ years of additional experience working in data warehousing and business intelligence tools, techniques and technology is strongly desired
Expert knowledge of Netezza appliance (TwinFinn and Mako) systems- Architecture and system internals, including updates and features on new versions
At least 5+ years of SQL programming and Performance Tuning experience
Expert level experience in administering large databases in mission critical environment
Extensive experience with different backup/restore and disaster recovery solutions
Excellent Communication skills, strong teamwork and organization skills
Positive attitude, problem solving skills and self-initiative are must-have qualities Experience: Proven work experience as a system or network administrator
Key skills: 3+ years of Unix sys admin experience, MUST HAVE BOTH sys admin and Netezza DBA experience
Princeton Information is one of the nation's top five privately-held IT consulting firms, in business since 1985. Princeton Information services a clientele of primarily Fortune 500 companies nationwide. With annual revenues over $120 million, Princeton Information operates across the US from multiple regional offices.
Our Commitment to Our Consultants
As a privately held company, Princeton Information is solely committed to the success of clients and consultants - not to any shareholders. PI's success is grounded in the relationships we build with our consultants. We seek the best people; provide career path counseling; as well as the most challenging opportunities in business and in IT. As part of its culture of loyalty and commitment to its consultants, Princeton Information is committed to doing all we can to ensure our consultants have the best possible search, placement and work experience possible.
Working with one Princeton Recruiter will gain you access to over 500 open requirements with the top clients in the US across all industries (finance, insurance, pharmaceutical, commercial, telecom, media, manufacturing) nationwide. Our local recruiters have in-depth knowledge of our clients and opportunities. They will work with you to find you the best possible opportunities for you and your career.
Our relationships with our clients, as well as our consultants, are critical to our success! We have a robust sales organization that ensures that Princeton has the inside track on what attributes a person needs in order to be successfully placed and engaged at our clients. We know the technical and non-technical skills that our clients are looking for and we ensure that you are educated about the client prior to your interview with them. Princeton is committed to going above and beyond to ensure that each meeting you have with a client is a successful one!
Access, Analysis, Application, Architecture, Bash, Business Intelligence, Capacity Planning, Consulting, Database, Database Administration, Data Warehouse, DBA, Development, Disaster Recovery, Engineer, Engineering, Hardware, IBM, IT, Linux, Management, Metrics, Network, Networking, Network Administrator, Performance, Perl, Programming, Python, Security, Software, SQL, Sys Admin, System, Systems, Systems Administrator, TCP/IP, Telecom, Unix
Princeton Information Ltd