Job Information
ConEdison Oracle GoldenGate DBA - IT Integration Services in New York, New York
Oracle GoldenGate DBA - IT Integration Services
Job Info
111429
Posting Expiration Date:Apr 30, 2024
Schedule Type:Full-Time
Minimum Salary:$95000
Maximum Salary:$125000
Organization:IT Engineering & Operations
Department:Architecture/Digital Platforms
Section:IT ENG Integration Services
Location:NY-New York-4 Irving Pl Headquarters
Similar Jobs
Sr System Cyber Analyst - Cyber Governance and Information Protection (https://careers.coned.com/jobs/14292052-sr-system-cyber-analyst)
Manager - Cybersecurity Operations
Manager- Datatbase Lead (https://careers.coned.com/jobs/14208539-manager)
Sr System Analyst- Vulnerability Management Lead
Business Relationship Manager- IT BSD Customer Engagement DCX (https://careers.coned.com/jobs/14194786-systems-manager)
Technical Associate-IS Cyber Security Operations
Job Description
Mission Statement
- Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) employees are required to follow health, safety, and environmental policies, EEO, Standards of Business Conduct, and all other applicable company policy and procedures. We all share a responsibility to advance the company’s mission by excelling at our three corporate priorities – safety of our people and the public, operational excellence in all that we do, and ensuring the best possible customer experience.
Core Responsibilities
Provide architectural leadership focusing on data and database administration, including designing database schema and data integration
Administer and configure Oracle GoldenGate 21c extracts/replicates, GoldenGate High Availability (HA) and integrate with monitoring tools such as Oracle Enterprise Manager (OEM)
Investigate, analyze and resolve technical issues and perform root cause analysis; configure error handling for restart, logging, production support, and status reporting; performance tune in GoldenGate replication environments
Assess the impact of vendor vulnerability announcements and work to remediate any exposures
Use database administration tools such as Performance Pack, SQL Navigator, TOAD, PL/SQL, and SQL Loader; run application and queries using AWR, ASH, ADDM, OEM and write custom scripts in UNIX/PERL; and perform database monitoring, replication and performance tuning
Document database technical and conceptual specifications in support of migration strategies, assess risks and dependencies, and potential impact on business operations; analyze business requirements and presents solution options
Must be flexible and able to work off-hours as required to support deployments, resolve production problems or respond to corporate emergencies
Perform other related tasks and assignments as required
Required Education/Experience
Bachelor's Degree Bachelor's Degree preferably in Information Technology, Computer Science or Engineering and with a minimum of (3) years of IT experience or
Associate's Degree Bachelor's Degree preferably in Information Technology, Computer Science or Engineering and with a minimum of (5) years of IT experience or
High School Diploma/GED with a minimum of (7) years of IT experience preferably in Information Technology
Relevant Work Experience
Used Oracle GoldenGate and features/functions such as integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate Required
Installed, configured, and supported GoldenGate 12c and higher, and GoldenGate downstream mining, and integrated components for replication; performed GoldenGate upgrades, replication, error resolution, and restarts Required
Understands cybersecurity principles, controls over PII/sensitive data, and patch management strategies Required
Administered Oracle Databases, Oracle HA (High Availability), Exadata, DataGuard; planned and implemented physical and logical structures of small to large databases Required
Developed disaster recovery design/architecture; used High Availability and performed system failovers of GoldenGate and databases; performed database backups; used backup utilities such as expdp and impdp Required
Developed written policy and procedures, job aids and/or instructions Required
Skills & Ability
Ability to influence internal and/or external constituents
Well organized, detail oriented and flexible to handle multiple assignments
Performs work independently with minimal supervision
Strong written and verbal communication skills
Licenses & Certifications
- Driver's License Required
Physical Demands
Must push, pull, lift up to 40 pounds
Must sit or stand to use a keyboard, mouse, and computer for entire shift
Must have excellent manual dexterity and be able to use hands for entire shift
Must stoop, bend, reach and kneel throughout the workday
Must be able to read small print and symbols.
Other Physical Demands
Must be able to respond to Company emergencies by performing a System Emergency Assignment to restore service to our customers.
Available to work off hours as operationally required. May need to work in other company locations, as required.
Technical Difficulty Statement
- For technical issues, please contact us at [email protected]
Equal Opportunity Employer
- Consolidated Edison Company of New York, Inc. (Con Edison), Orange & Rockland Utilities (O&R), and Consolidated Edison Transmission (CET) are equal opportunity employers. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of the individual’s actual or perceived disability, protected veteran status, race, color, creed, religion, sex, age, national origin, gender, gender identity, gender expression, genetic information, marital status, sexual orientation, citizenship, domestic violence victim status, or any other actual or perceived status protected by law.