DBA & Application Developer – Onsite in Anaheim

TEKsystems; Anaheim (CA); On-site; USD 83,000 - 90,000; Full time

Job summary

City of Anaheim is seeking a Junior Database Administrator and Applications Developer/Analyst to assist the Database Team with management of city databases and support business applications. Primary duties include maintenance, performance tuning, and development of SQL queries and interfaces.

The role requires a Bachelor's degree in CS or IS, experience with MS SQL Server/Oracle, scripting (PowerShell/Python), and willingness to work onsite during city hours.

Qualifications

• Bachelor’s degree preferably in Computer Science, Information Systems and/or certifications in database related technical areas.
• Experience in applications development, applications support and maintenance.
• Experience in managing MS SQL Server database and/or any other relational, open source, small-scale database systems.
• Experience installing, configuring and upgrading MS SQL Server and/or other relational or open-source databases
• Proficiency in developing and/or maintaining SQL queries, triggers, stored procedures, performance tuning, etc.
• Experience with database backup, restore, replication, recovery, and disaster recovery planning.
• Experience with MS SQL Server High Availability/Disaster Recovery solutions
• Hands-on experience using scripting languages PowerShell, Python or other related methods
• Working knowledge on Windows Server and/or Linux Operating systems
• Strong analytical and good problem solving, troubleshooting and issue resolution, organization and planning skills.
• Ability to learn quickly and adapt to multi-platform technical environment.
• Availability/ability to multi-task and provide off-hours support for production related database issues/incidents and/or technical environment support.
• Availability for oncall rotations or afterhours maintenance windows.
• Willingness to go through and complete the Anaheim Police Department security clearance process.

Responsibilities

• Assist DBA Team In The Following Activities
• Maintain database systems such as MS SQL Server, Oracle and other open source or small-scale databases.
• Administer databases in production and nonproduction environments.
• Monitor DB performance and optimize queries, indexes, and system parameters.
• Install, configure, and upgrade database servers, apply patches, DB updates and perform migrations.
• Setup and administer high availability configuration and data replication
• Perform regular backups and test restores.
• Perform database planning activities such as database design, data modeling, normalization, performance tuning, etc.
• 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 or deployments.
• Maintain various applications for city departments including application upgrade, patch maintenance and other related maintenance activities.
• Develop and maintain related applications and interfaces in support of city departments initiatives.
• Gather business requirements and document specifications for development of application, reports and interfaces.
• Coordinate with city staff, applications and software vendors in terms of applications and database related support, technical environment incidents and issue resolution.
• Ability to support the citys 24x7 business operations and be available onsite during the citys business hours.

Skills

ms sql server

Database administrator

application development

application support

application maintenance

sql development

database backup

database recovery

disaster recovery

database performance tuning

powershell

python scripts

Education

Bachelor's degree in Computer Science

Certifications in database related areas

Job description

City of Anaheim is seeking a Junior Database Administrator and Applications Developer/Analyst to assist the Database Team with management of city databases and support business applications. Primary duties include maintenance, performance tuning, and development of SQL queries and interfaces.

The role requires a Bachelor's degree in CS or IS, experience with MS SQL Server/Oracle, scripting (PowerShell/Python), and willingness to work onsite during city hours.