DBA With Application Developer Experience

MySQL Linux Planning Operations Leadership Management PostgreSQL Multitasking Data Modeling Backup Devices Quick Learning Windows Servers Problem Solving Database Design Database Backup Computer Science Oracle Databases Stored Procedure Database Systems Vendor Management Technical Support Technical Writing Disaster Recovery Database Upgrades Windows PowerShell Performance Tuning Business Valuation Security Clearance Data Normalization Query Optimization Report Development Business Operations Information Systems Systems Development Scripting Languages Computer Engineering Microsoft SQL Servers Business Requirements Requirements Analysis Full Stack Development Application Development Database Administration Business Transformation SQL (Programming Language) Verbal Communication Skills Interpersonal Communications Python (Programming Language) Troubleshooting (Problem Solving) Enterprise Application Integration $124,800 - $135,200 / yr Posted yesterday, Perform as a Junior Database Administrator and an Applications Developer/Analyst for the City of Anaheim. Primary responsibility is to assist the Database Team with management of various City databases which include maintenance activities of departments databases that support business applications. Secondary responsibility is for the support and maintenance of business applications which include systems development, applications upgrades and maintenance of reports and interfaces., 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.

College degree preferably in the field of 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 disasterrecovery 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 work closely with developers, architects, and business applications users.

Excellent verbal communication, interpersonal skills, technical writing and documentation 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.

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, oracle database, open source databases, mysql, postgresql, data modeling software, database design, data normalization, application integration, application interfaces, report development, report maintenance, requirement gathering, requirements documentation, vendor management, third party application support

Top Skills Details

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 AND EXPERIENCE REQUIREMENT: Bachelors degree preferably in the fields of Computer Science, Information Systems, Computer Engineering and/or certifications in database related technical areas, Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

PERIOD OF PERFORMANCE: 7th year of a 4 year contract with 2 renewals for 2 years each. (Completed the 4 year contract and first 2 year renewal, now on year 1 of the second 2 year renewal.) Job Type & Location

This is a Contract to Hire position based out of Anaheim, CA. Pay and Benefits

The pay range for this position is $60.00 - $65.00/hr.

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company., Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.