Database Administrator

Microsoft SQL Server, SQL, ETL, DBA, Client/server, Microsoft Dynamics GP, MySQL, Quick learner, Microsoft SharePoint, Troubleshooting, ServiceNow, Esri, Oracle, Data QA, Microsoft Exchange, Failover, Microsoft SQL Server DBA, Microsoft SSRS
Full Time
$86,596 - $112,528
Work from home available Travel not required

Job Description

DESCRIPTION:
Southern California Association of Governments (SCAG) is seeking a highly skilled and analytical Database Administrator. When you join SCAG, you can expect a culture where collaboration and team work is fostered. SCAG's workforce is highly educated, passionate, and committed to innovation that improves the quality of life for all Southern Californians. SCAG supports a work environment that promotes achievements while maintaining work/life balance.


The Database Administrator works as an essential contributor to SCAG's IT team. Reporting to the Manager of Application Development & Support, the Database Administrator is responsible for supporting and maintaining application, GIS, and reporting databases. This position performs critical database maintenance, system administration, and data analysis activities. The Database Administrator will work closely with end-users, application development teams, and independently to facilitate the organization's use of databases across multiple applications.


SCAG's Application Development and Support team is responsible for many of SCAG's core technology systems and involved in multiple SCAG initiatives. The team develops, manages, tests, supports, maintains, and consults on applications including region shaping metropolitan
planning systems, operationally focused finance and support systems, and public facing information sharing systems. Some of the current applications and technologies used include Microsoft Great Plains (GP), WorkPlace, OnBase, Microsoft CRM, custom Inter-Government
Review (IGR), custom Finance Management Systems(FMS), custom Active Transportation Database (ATDB), Microsoft Dynamics 365, ESRI ArcGIS, ArcGIS Online, ServiceNow, Microsoft SQL Server, SQL Server Reporting Services (SSRS), and Crystal Reports.


OUR LOCATION
SCAG headquarters is located in the hub of busy downtown Los Angeles, at Figueroa and 7th streets. SCAG has recently relocated to the 900 Wilshire Building, a new, multi-use hotel and office complex that features state of the art architecture and technology. The downtown area has expanded with LA Live, new restaurants, music, sports, shopping, libraries, museums and theaters. SCAG is in a culturally diverse area near Koreatown, Little Tokyo, Chinatown, Olvera Street and Grand Central Market. Southern California boasts near-perfect weather and close proximity to mountains, beaches and deserts, which encourages physical fitness and year-round activities.


For ease of commuting, the LA office is located across the street from the Metro Red Line 7th St. station and is easily accessible by commuter trains and buses serving surrounding areas. Metro's light rail and subway connect downtown LA to Hollywood, Universal City, Santa Monica,
Pasadena, Azusa, Long Beach and many vibrant and up-and-coming neighborhoods.


WHO WE ARE:
Founded in 1965, the Southern California Association of Governments (SCAG) is a Joint Powers Authority under California state law, established as an association of local governments and agencies that voluntarily convene as a forum to address regional issues. Under federal law, TheSCAG region encompasses six counties (Imperial, Los Angeles, Orange, Riverside, San Bernardino and Ventura) and 191 cities in an area covering more than 38,000 square miles. The agency develops long-range regional transportation plans including sustainable communities'
strategy and growth forecast components, regional transportation improvement programs, regional housing needs allocations and a portion of the South Coast Air Quality management plans. Currently, the Regional Council consists of 86 members.


WHAT WE BELIEVE
MISSION
To foster innovative regional solutions that improve the lives of Southern Californians through inclusive collaboration, visionary planning, regional advocacy, information sharing, and promoting best practices.


VISION
Southern California's Catalyst for a Brighter Future.


SCAG CORE VALUES

  • Be Open: Be accessible, candid, collaborative and transparent in the work we do.
  • Lead by Example: Commit to integrity and equity in working to meet the diverse needs of all people and communities in our region.
  • Make an Impact: In all endeavors, effect positive and sustained outcomes that make our region thrive.
  • Be Courageous: Have confidence that taking deliberate, bold and purposeful risks can yield new and valuable benefits.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

  • Create and maintain enterprise databases and system documentation in a client/server environment.
  • Design and document schemas for application databases, operational data stores, and data warehouses. Ensure each database is used for its intended purpose. Create data structures and indexes for efficient operations.
  • Support data protection and resiliency efforts by performing critical database maintenance, backup, restoration, and upgrade tasks.
  • Secure databases by setting up user accounts and groups with proper levels of access.
  • Monitor databases to ensure databases are up and in a healthy state by checking for potential data consistency issues and auditing data for potential problems.
  • Develop SQL statements. Create and optimize queries; develop stored procedures; create views; optimize data structures; support application development efforts.
  • Create, maintain, and monitor extraction, transform, and load (ETL) processes and jobs to ensure data quality and consistency.
  • Provide database support by troubleshooting issues related to SQL Server, addressing assigned support and maintenance tickets, and resolving database issues as they arise.
  • Participate in the physical and logical design of data/information system architecture and data file structure.
  • Provide on-going capacity analysis and planning to determine future hardware requirements and/or configuration changes.
  • Maintain and enhance the agency's CMS (Communication Emergency System) and the ISD Work Request System.
  • Act as backup for other Database Administrators when they are unavailable.
  • Support general system administration efforts across SCAG's portfolio of applications such as Windows Server, Microsoft GP, Microsoft Dynamics 365, Microsoft SharePoint, Office 365, OnBase, ArcGIS Online.
  • Provide technical assistance to staff members throughout the agency regarding database management policies, procedures, and operations; assist with training users.

MINIMUM QUALIFICATIONS:
EDUCATION: Equivalent to a Bachelor's degree from an accredited college or university inComputer Science or related field.

EXPERIENCE: Three years of increasingly responsible database management experience that includes designing schemas, maintaining databases, analyzing data, and SQL programming.

IDEAL CANDIDATE:
The ideal candidate:

  • Has demonstrated experience database administration
  • Has experience developing complex SQL statements
  • Is quick learner with the aptitude to learn new systems
  • Is an analytical thinker with a strong attention to detail
  • Thrives in a fast-paced environment with a steady workload
  • Has strong communication skills with the ability to communicate technical information to those without the necessary technical background

KNOWLEDGE OF: Database queries, theory, and design; Microsoft SQL Server Administration including installation, configuration, and upgrades; database design related to application development and reporting data stores; troubleshooting MS SQL Server issues, SQL programming issues, and database performance issues; administrating and supporting a GeoDB and ESRI products; administering and supporting Postgres, MySQL, or Oracle; working with SSRS and SSIS; building and supporting a data warehouse; creating Entity Relationship (ER) diagrams; working with Microsoft Dynamics GP, Microsoft Dynamics CRM, and SharePoint; working with the Microsoft technology stack such as Active Directory, Exchange, Office 365, SQL
server, Skype, Onedrive, and Office; implementing and managing Cloud architecture services such as AWS and Azurel; IT service management practices and tracking based on ITIL and ServiceNow; developing complex SQL; knowledge of SQL; storage technologies and networking; routine maintenance, recovery, and handling failover of a database.

ABILITY TO: Plan and organize multiple assignments to meet deadlines; plan data flows for a new or revised database; map out conceptual design for a planned database in outline; refine the physical design to meet system storage requirements; refine logical design to translate into a specific data model; prepare and deliver public presentations and training; communicate clearly both orally and in writing; work cooperatively and productively as a team member; use analytical, strategic conceptual thinking, strategic planning and execution skills.

Important Applicant Information: Candidates must fill out the application and supplemental questions completely. Incomplete applications including references to see the resume for qualifications are incomplete and will be disqualified. Candidates are encouraged to provide accurate answers as SCAG will verify the qualifications for each candidate.


SCAG is an equal opportunity employer. SCAG's policy is to provide employment opportunity for all qualified persons. All applicants will be considered without regard to race, religion, sex (including gender, gender identity, gender expression and pregnancy), national origin, ancestry,
disability, medical condition, genetic characteristics or information, marital status, age, sexual orientation, military and veteran status.


The provisions of this job announcement do not constitute a contract, expressed or implied, andany provision contained in this job announcement may be modified or revoked without notice.

Posted By

Renee Lutz

900 Wilshire Blvd. Suite 1700 Los Angeles, CA, 90017

Contact
Dice Id : RTX1d5912
Position Id : 6267244
Originally Posted : 4 weeks ago
Have a Job? Post it

Similar Positions

SQL Database Administrator - Financial Services
  • Eleven Recruiting
  • Los Angeles, CA
SQL Database Administrator
  • R4 Solutions Inc.
  • Norwalk, CA
Sql DBA (Actively Interviewing)
  • Sysintelli, Inc.
  • Long Beach, CA
SQL DBA
  • i3 INFOTEK
  • Long Beach, CA
DBA - SQL Server, Azure, Production
  • Software Management Consultants, Inc.
  • Los Angeles, CA
SQL Server DBA
  • Launch Infotech
  • Signal Hill, CA
SQL DBA with Azure Migration
  • Bitsoft International, Inc.
  • Long Beach, CA
SQL DBA
  • Rudra Technologies
  • Torrance, CA
Sr. Database Administrator
  • AltaMed
  • Monterey Park, CA
Database Administrator III
  • SAIC
  • Anaheim, CA
LEAD DBA WITH SQL
  • XFORIA Inc
  • Long Beach, CA
SQL DBA
  • Robert Half Technology
  • Long Beach, CA
Database Administrator
  • Experis
  • Glendale, CA
Sybase DBA
  • Beacon Hill Technologies
  • Glendale, CA