The Department of Social Services (DSS) is comprised of the administrative units of the New York City Human Resources Administration (HRA) and the Department of Homeless Services (DHS). HRA is dedicated to fighting poverty and income inequality by providing New Yorkers in need with essential benefits such as Food Assistance and Emergency Rental Assistance. DHS is committed to preventing and addressing homelessness in New York City by employing a variety of innovative strategies to help families and individuals successfully exit shelter and return to self-sufficiency as quickly as possible. Information Technology Services (ITS) is DSSs technology services organization. ITS mission is to support the daily, emergent, and long-term needs of both agencies. ITS creates and enhances the technology infrastructure and computer applications that support HRA and DHS and develops applications, including a variety of client eligibility and recertification systems, case management systems, housing systems, employment/work engagement services, revenue producing computer matches, claiming systems, and personnel systems. Information Technology Services (ITS) is recruiting for one (1) IT Project Specialist, to function as Database Manager, who will: Manage AWS RDS environments running the Oracle engine, which comprise approximately 6070% of day-to-day operational focus. Provide extensive support for Oracle databases and handle DB2 administration, while also utilizing Microsoft AppDynamics for enterprise-level performance monitoring and diagnostics across all platforms. Oversee AWS RDS (Oracle Engine) CARES Project, administering RDS Oracle environments through AWS Console and CLI tools. Conduct proactive performance monitoring using CloudWatch, Performance Insights, and Query Editor; perform advanced SQL tuning and index optimization to improve query performance. Monitor storage utilization; add datafiles to maintain tablespace availability; manage connectivity through TOAD using RDS endpoints for diagnostics and schema review. Execute database patches and major version upgrades in coordination with AWS service teams; maintain replication consistency between primary and read-replica environments; generate real-time performance and compliance reports using AWS-native analytics and implement and manage encryption configurations, ensuring secure data at rest and in transit in compliance with organizational and regulatory standards.
1. A baccalaureate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and four years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or 2. An associate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and six years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or 3. A baccalaureate degree from an accredited college, and eight years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or 4. Education and/or experience which is equivalent to "1", "2", or "3" above.
- Extensive experience managing AWS RDS for Oracle, including configuration of parameter groups, snapshots, read replicas, and Performance Insights. - Skilled in monitoring and performance optimization using AWS CloudWatch, AppDynamics, and Oracle Enterprise Manager. - Strong hands-on expertise with Oracle 19c administration, covering AWR analysis, SQL tuning, Data Pump, and RMAN. - Proven ability to handle database migrations using AWS Database Migration Service (DMS), Oracle Data Pump, and GoldenGate. - Experienced in automating backup and recovery strategies, ensuring compliance with encryption at rest and in transit. - Proficient with tools such as TOAD, SQL Developer, and MobaXterm for diagnostics and schema management Knowledgeable in cross-platform database support, including DB2. - Adept at writing Bash and Shell scripts to streamline operations, analyze logs, and support automation. - Effective communicator with a track record of producing clear runbooks, health reports, and capacity planning documents.
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education's website at
New York City Residency is not required for this position.
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individuals sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
Benefits401(k)401(k) matchingBonus based on performanceCompetitive salaryHealth insuranceOpportunity for advancementPaid time offProfit sharingTraining & developmentResponsibilitiesStudy the most frequently used insurance plans to understand the various...
...visionary leader to serve as its next Dean of the Division of Social Science. This is a rare opportunity to shape a dynamic academic... ...vibrant community of scholars who advance foundational and applied research on some of the most pressing issues of our time - ranging...
...Compensation Insurance Compensation Job Summary We are seeking a knowledgeable and detail-oriented Classic American Automotive Car Parts Manager to oversee parts operations for our shop specializing in classic American muscle cars. The ideal candidate will have a...
...part-time nanny to help us with our primary school-aged child. The position is live out, meaning you will not be required to stay at our home overnight. We are looking for someone who can commit to regular hours and can bring a positive and engaging attitude to our...
...product and lead the design lifecycle from discovery through design validation and customer adoption + Apply and adapt appropriate research techniques and methods for specific project needs + Engage with customers to understand their unique needs for our products,...