Lead Database

Job Description

Who we are looking forAs part of State Street s continued investment in Resiliency, we are looking for an individual with an analytical mind and a detailed understanding of IT Lifecycle. This team member, along with others, will work within the IT Infrastructure organization to help deliver organizational Lifecycle goals.What you will be responsible forAs a member of the Lifecycle team your emphasis will be working to upgrade or migrate databases to newer versions while following standard protocols, processes and adhearing to State Street Lifecycle methodology.What we valueSuperior communication skills. Flexibility and strong tenants for reaching desired outcome. Taking ownership, problem solving and working Collaboratively are important skills in this role.These skills will help you succeed in this role

• 10 years experience working in an Information Technology role
• 5 years experience in a high-tech customer-facing role (i.e. Professional Services, Solution Architecture, Systems Administrator, Engineering or Consulting)
• 7 year s hands-on experience with database migrations and related technologies; experience providing senior level operational support and implementation of large-scale, enterprise level solutions (or demonstrated ability to work at this level experience with solving problems and making decisions; experience with the fundamentals of configuration of applications)
• Manage Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high level of performance, availability, and security.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Experience and indept knowledge of Oracle, Exadata, DB2 and Sybase
• Experience with Oracle RAC preferred
• Experience and indepth knowledge with Oracle RDBMS multi-terabyte standalone and grid infrastructure (RAC/ASM) on 11g, 12c, 19c across multiple platforms (Exadata, RHEL, Solaris, AIX, etc.)
• Experience and indept knowledge with Oracle GoldenGate and Oracle DataGuard
• Previous experience with the design of infrastructure and integration into new and existing database systems
• Experience with infrastructure and database theories, principles and concepts, application infrastructure and standards, networking fundamentals, physical server architecture, and virtualization technologies (i.e. VMware, Hyper-V and LAN/WAN/Firewall/VPN networks
• Understand WAN/LAN concepts and the TCP/IP protocol stack
• Excellent written and verbal communication
• Flexible, team player, get-it-done personality
• Ability to work in a rapidly changing environment
• Ability to multi-task while maintaining high quality of deliverables

Education & Preferred Qualifications

• Bachelor s degree in Information Technology; Computer Science or related technical field
• Working knowledge of ticketing systems; creating, updating and closing tickets
• Strong customer service customer service skills (both written and verbal)
• Excellent interpersonal skills, ability to listen and understand what is being described
• Experience with one or more cloud providers such as Oracle cloud, AWS, Azure and Google Cloud Platform.
• Ability to effectively deliver and execute technical projects across multiple engagements in a customer-facing-capacity

Must have skills:

• Database upgrades and migrations across various Oracle versions and operating systems
• High-Availability design
• Performance Tuning
• Backup recovery plans and execution
• Unix scripting and Automation

Nice to have skills:

• Experience with using ServiceNow
• Basic knowledge of SSIS/SSRS
• Knowledge with SQL Server 2008,2012, 2014, 2016, 2017,2019 support various configurations using Always On, Mirrors, etc.

Additional requirementsWhy this role is important to usOur technology function, Global Technology Services (GTS), is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We re driving the company s digital transformation and expanding business capabilities using industry best practices and advanced technologies such as cloud, artificial intelligence and robotics process automation.We offer a collaborative environment where technology skills and innovation are valued in a global organization. We re looking for top technical talent to join our team and deliver creative technology solutions that help us become an end-to-end, next-generation financial services company.Join us if you want to grow your technical skills, solve real problems and make your mark on our industry.,

Keyskills :
content managementoracle racoracle rdbmsrecovery plansproblem solvingdatabase serversit infrastructureticketing systemsfinancial servicesoperational supportserver architecture