Junior Database Administrator and Applications Developer

Eliassen Group; Anaheim (CA); On-site; USD 76,000 - 83,000; Full time

Benefits offered by this job

Medical, Dental, Vision benefits

401k with company matching

Life insurance

Job summary

Eliassen Group is seeking a Junior Database Administrator and Applications Developer/Analyst for on-site work in Anaheim, CA to support the City of Anaheim account.

The role combines database administration (MS SQL Server, Oracle) with application development and maintenance, including upgrades, reports, interfaces, and deployments. Candidates should be US citizens and be prepared for a W2 contract-to-hire arrangement.

Qualifications

• Experience with administering MS SQL Server and Oracle databases.
• Willingness to work on-site in Anaheim and support 24x7 operations during business hours.
• Willingness to obtain Anaheim Police Department security clearance.

Responsibilities

• Maintain database systems (MS SQL Server, Oracle) in production and non-production environments.
• Monitor performance and optimize queries and indexes.
• Install, configure, and upgrade database servers; apply patches.
• Set up high availability and data replication.
• Develop, update, and optimize SQL queries, stored procedures.
• Provide on-call support and city-wide maintenance; support interfaces and deployments.

Skills

MS SQL Server

Database administration

SQL development

PowerShell

Python

Windows Server

Linux

Backup & Recovery

Education

College degree in CS or IS

Tools

Oracle

Job description

Description

On-site in Anaheim, CA

Our client seeks a Junior Database Administrator and Applications Developer/Analyst to support the City of Anaheim account. The role will assist the database team with administration and maintenance of MS SQL Server, Oracle, and other databases, and will also support and maintain business applications, including upgrades, reports, interfaces, and deployments. The position requires collaboration with city staff and vendors, attention to performance, reliability, and security, and availability to support 24x7 city operations during business hours on-site.

Due to federal security clearance requirements, applicant must be a United States Citizen. This is a contract to hire opportunity. Applicants must be willing and able to work on a w2 basis and convert to FTE following contract duration. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $55.00 to $60.00/hr. w2

Responsibilities

• Assist the DBA team in maintaining database systems such as MS SQL Server, Oracle, and other open source or small-scale databases.
• Administer databases in production and non-production environments.
• Monitor database performance and optimize queries, indexes, and system parameters.
• Install, configure, and upgrade database servers, apply patches and updates, and perform migrations.
• Set up and administer high availability configurations and data replication.
• Perform regular backups and test restores.
• Plan and design databases, including data modeling, normalization, and performance tuning.
• Develop, update, and optimize SQL queries, triggers, and stored procedures.
• Monitor performance and troubleshoot slow queries or server bottlenecks.
• Support development teams with schema changes and deployments.
• Maintain applications for city departments, including upgrades, patching, and related maintenance.
• Develop and maintain related applications and interfaces to support departmental initiatives.
• Gather business requirements and document specifications for applications, reports, and interfaces.
• Coordinate with city staff and software vendors on application and database support and incident resolution.
• Support 24x7 business operations and be available on-site during city business hours.

Experience Requirements

• Experience in applications development, support, and maintenance.
• Experience managing MS SQL Server and/or other relational or open-source databases.
• Experience installing, configuring, and upgrading MS SQL Server and/or other relational or open-source databases.
• Proficiency with SQL development including queries, triggers, stored procedures, and performance tuning.
• Experience with backup, restore, replication, recovery, and disaster-recovery planning.
• Experience with MS SQL Server high availability and disaster recovery solutions.
• Hands-on experience with scripting such as PowerShell or Python.
• Working knowledge of Windows Server and/or Linux.
• Strong analytical, troubleshooting, organization, and planning skills.
• Ability to work closely with developers, architects, and business application users.
• Excellent verbal communication, interpersonal, technical writing, and documentation skills.
• Ability to learn quickly and adapt to a multi-platform environment.
• Availability to multi-task and provide off-hours support for production issues and technical environment support.
• Availability for on-call rotations or after-hours maintenance windows.
• Willingness to complete the Anaheim Police Department security clearance process.

Education Requirements

• College degree preferably in Computer Science or Information Systems, and/or certifications in database-related technical areas.