Responsible for working with user area to determine overall database and application requirements. Using technical and analytical expertise, develops recommendations for database designs and prepares detailed specifications and flowcharts. Responsible for administering procedures for backup recovery, disaster recovery, and performance analysis and database tuning. Coordinates the installation of systems. Determines and resolves problems in support of production databases. Provides training and technical assistance to more junior staff. Leads others to solve complex problems takes a broad perspective to identify innovative solutions. Works independently, with guidance in only the most complex situations. May lead teams or projects.
PGIM, the global investment management businesses of Prudential Financial Inc., is one of the world’s leading money managers. With offices in 16 countries and over $1 trillion in assets under management, clients rely on our risk management expertise, intellectual capital and creative solutions to realize their investment objectives. Our distinct multi-manager model delivers a broad suite of actively-managed solutions in the areas of public and private fixed income, equities and real estate to serve our clients’ needs. We are passionate about delivering investment returns for our clients and dedicated to our greatest asset – our people. Do you want to be part of a multi-manager model that enables each business to maintain its own investment culture? Learn more about who we are and how we can work together, please visit: www.pgim.com
PGIM Infrastructure & Technology Services
The PGIM Infrastructure & Technology Services team is a dynamic group that collaborates with Prudential’s Corporate Technology organization and our PGIM business partners to provide timely technical services and support for critical systems. Our goal is to offer premier technology integration and services to PGIM. Our Technology team is seeking an experienced Senior Database Administrator.
As a Senior Specialist, Database Administrator, you will support and administer Development, Test/QA, Production and Business Continuation database environments. Additionally, you will own and resolve database related incidents and requests while ensuring that these are resolved within agreed SLAs and guidelines. Are you passionate about using your technical and analytical expertise to develop recommendations for database designs and prepare detailed specifications and flowcharts? If you are proficient in SAP ASE (Sybase), SAP Replication Server and SQL Server, including SQL query tuning, UNIX scripting, and Powershell then this is the role for you.
Handling the administration of SAP ASE(Sybase), Heterogeneous Replication Server, SQL Server running on Microsoft Windows and Linux.
Handling enterprise RDBMs across multiple platforms and environments – SAP ASE(Sybase), SQL Server.
Installing and Configuring Database instances
Administering, maintaining, designing and implementing policies and procedures for ensuring the security and integrity of the database
Configuring SAP ASE Replication Heterogenous Server.
Assisting in performance tuning – Sybase / SQL Server queries.
Restoring development and test environments as per application group requirements
Managing autosys jobs
Monitoring the databases and responding to alerts
Running reports on capacity planning on all databases / database machines
Monitoring Solarwinds and identify issues with application queries
Participating in business continuity planning tests
Participating in design & configuration of database systems
Building, improving and maintaining documentation
Aiding in Audits – Internal or External.
Administering procedures for backup/recovery, disaster recovery, and performance analysis and database tuning
Coordinating the installation of systems
Resolving problems in support of production databases
Delivering training and technical assistance to more junior staff
Leading others to solve complex problems; taking a broad perspective to identify innovative solutions
Working independently, with guidance in only the most complex situations
May lead teams or projects
Does this sound like you? Our successful candidate has:
Bachelor's degree in Computer Science, related field or equivalent work experience required
At least 5-8 years of experience in SAP ASE 16, SQL Server, SAP Replication server
Knowledge of SAP ASE, SQL Server and Replication server
Knowledge of Jira/Confluence/Jenkins
Knowledge of k-shell scripting, Perl, Windows command line and Powershell
Knowledge of database connectivity - JDBC, ODBC, CLI
Oracle a plus.
Hadoop, AWS or Azure a plus.
Hardware knowledge a plus
Excellent written and verbal skills
Good interpersonal skills
Flexibility to succeed whether assigned large project initiatives or routine maintenance and support tasks
Ability to work equally well independently and in a team environment
Prudential is a multinational financial services leader with operations in the United States, Asia, Europe, and Latin America. Leveraging its heritage of life insurance and asset management expertise, Prudential is focused on helping individual and institutional customers grow and protect their wealth. The company's well-known Rock symbol is an icon of strength, stability, expertise and innovation that has stood the test of time. Prudential's businesses offer a variety of products and services, including life insurance, annuities, retirement-related services, mutual funds, asset management, and real estate services.
We recognize that our strength and success are directly linked to the quality and skills of our diverse associates. We are proud to be a place where talented people who want to make a difference can grow as professionals, leaders, and as individuals. Visit www.prudential.com to learn more about our values, our history and our brand.
Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, genetics, disability, age, veteran status, or any other characteristic protected by law.
Note that this posting is intended for individual applicants. Search firms or agencies should email Staffing at email@example.com for more information about doing business with Prudential.