Senior Database Administrator - 1709984
Company: Fidelity Investments
Location: Durham, NC
Posted on: November 10, 2017
Job Description:
Duties: Designs, implements, monitors, and tunes databases for
various product lines. Implements replication and disaster recovery with
Sybase Replication Server and MS SQL Server Native Replication.
Performs SQL tuning, database application design, and physical data
modeling. Installs and configures SQL Server Active/Active and
Active/Passive clusters. Performs Sybase/SAP Replication Server 15.7x
installation and configuration. Primary Responsibilities: • Implements cloned environments within the datacenter for
testing purposes. • 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 SQL Server and Sybase 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 SQL Server and Sybase
environments. Candidate must also possess: Demonstrated Expertise (“DE”)
performing database design and programming with Sybase Adaptive Server
Enterprise, Replication Server, and Sybase IQ Server; DE executing
Sybase Replication Server advanced setup (MSA, warm-standby, function
string, and data assurance product); performing Sybase ASE 15.x upgrade
and Sybase IQ setup, upgrade, and administration; and executing Heterogeneous replication set-up between Sybase, SQL Server, and
Oracle systems; DE performing database troubleshooting, including read
shared memory dump, analyzing/decrypting stack trace, and advanced
performance tuning and query optimization (Optdiag, sysmon, spinmon, MDA
tables, and DBCC trace commands); DE performing data modeling, database
design, Transact SQL programming, Open Client programming, performance
and tuning issue troubleshooting, and security administration. To apply, visit http://jobs.fidelity.com and search for Job
Number 1709984.
Keywords: Fidelity Investments, Rocky Mount , Senior Database Administrator - 1709984, Finance , Durham, NC, North Carolina