Junior Database Administrator
14 hours ago
New York
Job Description Job Code F1726IT Department Name IT Infrastructure Reports To Manager, DevOps FLSA Status Exempt Union Code N/A Management No About Us: About Us: Building Services 32BJ Benefit Funds (“the Funds”) is the umbrella organization responsible for administering Health, Pension, Retirement Savings, Training, and Legal Services benefits to over 185,000 SEIU 32BJ members. Our mission is to make significant contributions to the lives of our members by providing high quality benefits and services. Through our commitment, we embody five core values: Flexibility, Initiative, Respect, Sustainability, and Teamwork (FIRST). By following our core values, employees are open to different and new ways of doing things, take active steps to improve the organization, create an environment of trust and respect, approach their work with the intent of a positive outcome, and work collaboratively with colleagues. The Funds oversees and manages $11 billion of dollars in assets, which are made up of many, varied and complex funds. The dollars come from a number of sources, including the property owners who pay into the funds on behalf of their employees, and as such, requires those who oversee and manage the money to be highly skilled financial management people. 32BJ Benefit Funds will continue to drive innovation, equity, and technology insights to further help the lives of our hard-working members and their families. We use cutting edge technology such as: M365, Dynamics 365 CRM, Dynamics 365 F&O, Azure, AWS, SQL, Snowflake, QlikView, and more. Please take a moment to watch our video to learn more about our culture and contributions to our members: youtu.be/hYNdMGLn19A Job Summary: Under the supervision of the Manager, DevOps and in close partnership with the Senior Database Administrator, the Junior Database Administrator provides day-to-day operational support for on-premises and cloud database environments. This role is designed as a developmental position that supports ongoing database migrations, system modernization, and daily operational tasks while building hands-on experience in enterprise database administration. The Junior DBA assists with database maintenance, monitoring, documentation, and troubleshooting, and gradually assumes increased responsibility as skills and experience grow. Essential Duties and Responsibilities: Essential Duties and Responsibilities: • Assist with the administration and support of Microsoft SQL Server (on-premises and Azure SQL) environments., • Assist with administration and support environments that may include PostgreSQL or other modern database platforms as adopted by the Development team., • Perform routine database maintenance tasks, including backups, restores, monitoring, performance tuning (e.g., updating statistics, index maintenance, etc.) and health checks., • Support database availability, integrity, performance, and reliability under the guidance of the Senior DBA., • Assist in patch management and version upgrades., • Participate in high-availability and disaster recovery testing., • Support SQL Agent jobs and scheduled processes., • Assist with user access provisioning and periodic access reviews., • Support enforcement of least-privilege database permissions., • Monitor database activity alerts and escalate anomalies., • Assist with encryption configuration (at rest and in transit)., • Support vulnerability remediation efforts., • Assist with compliance, audit requests, and evidence collection related to database operations., • Follow established change management, incident management, and operational procedures., • Assist with database and application migrations from legacy operating systems and platforms to supported environments., • Gain hands-on exposure to Azure SQL, Azure data services, and DevOps workflows., • Participate in Infrastructure-as-Code and CI/CD database deployment workflows., • Contribute to automation initiatives to reduce manual operational tasks., • Support data validation, testing, and post-migration verification activities., • Help maintain migration documentation, runbooks, and checklists., • Assist with basic SQL development tasks, including queries, stored procedures, and performance troubleshooting under supervision., • Support ETL, data movement, and integration tasks using existing tools and frameworks., • Assist in supporting Azure-based data services as skills develop., • Participate in learning and supporting new database technologies aligned with organizational standards., • Participate in continuous improvement initiatives, • Contribute to knowledge-sharing within the team, • Maintain and update system documentation, operational procedures, and inventory records., • Work closely with DevOps, application development, and infrastructure teams., • Learn from and be mentored by the Senior Database Administrator., • Participate in project meetings and technical discussions as appropriate., • Build skills to support increased responsibility over time., • Perform tasks as required by management/supervisory staff., • Provide support after hours, and on weekends as needed. Qualifications (Competencies): Qualifications (Competencies): • 1–3 years of experience in IT operations, systems administration, application support, or database support, • Working knowledge of relational databases, preferably Microsoft SQL Server, • Basic SQL skills and understanding of database concepts, • Familiarity with database backup, restore, and monitoring tools, and database security fundamentals, • Familiarity with Windows or Linux server environments, • Experience working with ticketing systems and IT service management processes, • Strong troubleshooting, documentation, and communication skills, • Exposure to Azure SQL or cloud-based database platforms, • Exposure to PostgreSQL or interest in supporting open-source databases, • Basic understanding of data integration or ETL concepts, • Experience working in Agile or DevOps environments Soft Skills (Interpersonal Skills): Soft Skills (Interpersonal Skills): • Detail oriented with excellent organization and analytical skills., • Ability to plan and take initiatives to accomplish objectives in timely fashion., • Ability to prioritize work and meet deadlines., • Ability to establish and maintain effective working relationships with peers, project team members, supervisors, and employees from other departments., • Strong documentation and communication skills. Education: Education: Associate’s or Bachelor’s degree in Computer Science, Information Technology, or a related field or equivalent hands-on experience. Language Skills: Language Skills: Speak, read, write and understand English Reasoning Ability: Reasoning Ability: High Certificates, Licenses, Registrations: Certificates, Licenses, Registrations: Microsoft, Azure, or database-related certifications are a plus but not required. Shift Shift Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals to perform the essential functions. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals to perform the essential functions. • Under 1/3 of the time: Standing, Walking, Climbing or Balancing, Stooping, Kneeling, Crouching, or Crawling, • Over 2/3 of the time: Talking or Hearing, • 100% of the time: Using Hands Work Environment: Work Environment: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. • 1/3 to 2/3 of the time: Work near moving or mechanical parts, exposure to radiation, moderate noise.