Senior Database Administrator - 1800342
Company: Fidelity Investments
Location: Westlake, TX
Posted on: January 26, 2018
Job Description:
Duties: Implements and administers Netezza (NPS) servers.
Maintains user security in Oracle and Netezza. Performs database and server
monitoring using OEM and Crontab. Performs database performance analysis,
capacity planning, disaster recovery, system sizing, and ongoing
maintenance/tuning to ensure maximum performance on Netezza platform. Primary Responsibilities: • Works with solution architect team to implement new versions
and solutions. • Creates database packages, procedures, functions, and
triggers. • Creates and maintains standby databases. • Documents design, operational procedures, and standards for
complex and business critical databases. • Designs and tests recoverability for non-highly available databases. • Maintains technical implementations of operational
procedures. • Works directly with the user community for project
definition. • Identifies users and situations that may be hazardous to
the system/network. • Implements operational procedures to ensure network
integrity, physical protection, and authorized access to the network and
applications. • Assists in developing business cases to justify
information security architecture initiatives. Requirements: Bachelor’s degree (or foreign education
equivalent) in Computer Science, Computer Applications, Engineering,
Information Technology, Information Systems, Mathematics, Physics, or a
closely related field and three (3) years of experience in the job offered or
three (3) years of experience performing database administration across
IBM Netezza, Oracle, and Microsoft SQL Server environments; Or,
alternatively, a Master’s degree (or foreign education equivalent) in Computer
Science, Computer Applications, Engineering, Information Technology,
Information Systems, Mathematics, Physics, or a closely related field and
one (1) year of experience in the job offered or one (1) year of experience
performing database administration across IBM Netezza, Oracle, and
Microsoft SQL Server environments. Candidate must also possess: Demonstrated
Expertise (“DE”) performing IBM Pure Data Analytics Systems (Netezza)
administration, installations, security, performance, and hardware replacements;
and performing database administration within Oracle 11g Real
Application Cluster (RAC), including Oracle EXADATA solutions, Oracle
E-Business Suites R12, Microsoft SQL Server 2008/2005, and IBM DB2, within a
mission critical asset management application environment; DE performing Oracle
database replication and Cross-Platform Database Migration, using Golden
Gate/ZFS and Data Guard, for mission critical asset management
applications; DE testing backup and recovery scenarios using RMAN utility and
patching process for Oracle 11g GRID environments; DE performing query
tuning of and troubleshooting real-time mission critical database
applications, using Netezza and Oracle Enterprise Manager 12c; reviewing SQL to
identify bottlenecks; and providing performance tuning and
optimization recommendations based on Oracle AWR, ASH, and SQLT reports and
system diagnostics. To apply, visit http://jobs.fidelity.com and search for Job
Number 1800342.
Keywords: Fidelity Investments, Dallas , Senior Database Administrator - 1800342, Finance , Westlake, TX, Texas