Database Applications Analyst
Database Applications Analyst
Norwalk - La Mirada USD 12820 Pioneer Blvd. Norwalk, CA 90650. Salary: $5541.00 - $6760.00 per month (Full-Time)
Experience: 3 years in application, database development, programming, testing or administration.
Example of Duties:
Analyze, design, develop, program, implement, and maintain complex computer data software systems on appropriate platforms; perform routine systems administration tasks, such as installing new software and update patches; evaluate and implement and support multiple vendors, such as Microsoft SQL, MySQL, and Oracle database software on appropriate platforms as required by various business applications; maintain implementation of back-up, restart, and recovery procedures for the database management system files; extract data from the student information system and business financial system; create programming interface, generate reports, and prepare instruction for end-users; coordinate training and provide ongoing technical support to District and school personnel in the resolution of database systems issues; extract data from various legacy systems then design and convert them into a supported multi-user web application database platform; write or implement predefined interfaces between software systems to meet the District’s goal of creating an integrated database environment for all data; maintain scripts, programs, or other technology tools to identify data outside of normal bounds that may enter data warehouses(s); create external compliance reporting files, or paper reports, to meet state and federal compliance reporting standards; provide ad-hoc databases or file systems to combine and contrast different databases into one dataset (database) for research purposes using Integrated Technology standard toolset; participate in short- and long-range planning for the use of data (database) for the District; attend software conferences to maintain an expert level of knowledge on database management, data management, data cleansing, and linking of data sources for the advancement of the District; serve as a liaison with third-party vendors, Technology Services staff, and contractors; provide work direction and guidance to contractors; review completed work and work in progress for accuracy; perform other job-related duties as required.
Minimum Qualifications
License:
A valid California Driver’s License.
Knowledge of:
Principles, practices, and techniques of database structures and computer programming in client/server environments; methods used in database management to organize, access, test, secure, and assess data; principles and techniques of programming using computer languages; windows server and database technology; analytical systems for effective evaluation; cloud-based computing, Infrastructure as a Service (IaaS), Software, Defined Networking (SDN), and Storage Area Networks (SAN); methods of implementation of database systems and improvements; district student information system, such as Powerschool Student System, Crystal Reports, and CALPADS; fundamentals of time management; interpersonal relations skills using tact, patience, and courtesy; computer Operating Systems Windows 8, 10, Server 2012, 2016 Mac OS, HP-MPE, LINUX/UNIX, database engines, MSSQL Server, MS-ACCESS, and Filemaker Pro SharePoint Online; general working knowledge of CSS, C#, Visual Basic, Javascript, and SQL; web Technologies: Net Framework, PHP, REST-ful API’s, and Web services.
Ability to:
Analyze existing procedures and develop improvements for optimum use by Information Technologies; work effectively and independently in designing and implementing data management systems; analyze user needs and develop effective systems and programs; evaluate and interpret technical material and follow current trends and direction of database management systems; test, trouble-shoot, debug, and document programs; communicate effectively both orally and in writing; understand and follow oral and written directions; prepare clear, complete, concise reports and records; establish and maintain cooperative and effective working relationships with others; technical, analytical, and diagnostic skills.
Experience:
Three years work experience in application, database development, programming, testing, or administration.
Education:
Proof of High School Diploma or equivalency. Bachelor’s degree in Computer Science, Management Information Systems, Business Administration, or related field. Three years of working experience may be substituted for a Bachelor’s degree. Certification database administration, such as Microsoft SQL or Oracle highly desirable.