Database Analyst

19 Nov 2024

Vacancy expired!

Client: State of Maryland - MSDE

Job Title: Database Analyst

No. of Hours Per Week: 20

Start Date: ASAP

Location: 200 West Baltimore Street

Position Type: Part time

Interview Type: In-person/Webcam/Phone

Requirement ID: SMDORAC845PT

Maryland State Department of Education (MSDE)

Project:
The Maryland State Department of Education (MSDE or the “Department”), on behalf of the Maryland Longitudinal Data System (MLDS) Center, is issuing this CATS+ TORFP in order to acquire the services of an experienced Senior Database Analyst who can assist with ongoing obligations and provide guidance on Oracle database management, data analysis, and complex identity resolution procedures.

Responsibilities:
  • Receive data from various agencies and load the data into the centralized MLDS Center database system.
  • Develop guidelines for identity resolution.
  • Perform identity resolution procedures based on guidelines established.
  • Create complex data set files for use by researchers.
  • Develop data marts to support the MLDS Center reports and dashboards.
  • Develop logical and physical database designs and apply appropriate modifications to design models or database schema.
  • Analyze data received from various agencies and transform the data to meet the business and technical needs of the MLDS Center databases.
  • Load data into MLDS Center databases and perform data validation.
  • Ensure the data transformation and data loading is successful and accurate.
  • Implement Oracle security modules, such as data masking and data encryption, in order to maintain security and confidentiality of system data.
  • Perform data cleansing, data matching, and identity resolution functions within the database.
  • Provide weekly status reports which include, but are not limited to:
  • Tasks Completed
  • Tasks Planned
  • Risks/Issues
    • Perform other duties related to MLDS database analysis as assigned by the Contract Manager.

    Required Skills:

    Education:
    • Bachelor of Science degree in Computer Science, or related field, required.

    Experience:
    • Three (3) years of experience with education data.
    • Five (5) years of experience in Oracle database and in depth knowledge of Oracle database technology.
    • Five (5) years of experience in Oracle systems including Oracle Enterprise Manager 12c and Oracle Application Server.
    • Five (5) years of demonstrated experience designing, developing, implementing, maintaining and controlling Oracle Database Management Systems.
    • Five (5) years of experience in PL/SQL, extensive knowledge of structured query language procedures used in Oracle.
    • Five (5) years of experience with identity resolution.
    • Five (5) years of experience with exhibiting excellent communication skills, including creating written documentation.
    • Five (5) years of experience loading data into Oracle databases
    V Group Inc. is an IT Services company which supplies IT staffing, project management, and delivery services in software, network, help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR, CA, DE, FL, GA, IL, KY, MD, ME, MI, NC, NJ, NY, OH, OR, PA, SC, TX, VA, and WA. If you are considering applying for a position with V Group, or in partnering with us on a position, please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.Please share my contact information with others working in Information Technology.

    Website: www.vgroupinc.comLinkedIn: www.linkedin.com/company/v-group/Facebook: www.facebook.com/VGroupITTwitter: www.twitter.com/vgroupinc

    • ID: #23005740
    • State: Maryland Baltimore 21201 Baltimore USA
    • City: Baltimore
    • Salary: USD TBD TBD
    • Job type: Contract
    • Showed: 2021-11-19
    • Deadline: 2022-01-17
    • Category: Et cetera