Today
Secret
Unspecified
Unspecified
IT - Software
coronado island, CA (On-Site/Office)
Description
Database Analyst Programmer - Intermediate
San Diego, CA.
Description
The Senior Database Analyst/Programmer will analyze requirements and design, code, test, debug and document custom or framework-based front-end script and markup language under the general supervision of the Project Manager.
Duties and responsibilities
Collaborate with end users to identify needs and opportunities for improved data Design, create, maintain, and manage Enterprise Data Warehouses (EDW), data lakes, data marts, Operational Data Stores (ODS), Extract Transform Load (ETL) solutions, XML, indexes, T-SQL and data manipulation scripts, stored procedures, views, functions, reports and forms.
Apply DoD data standards to all software applications and database data elements, ensuring logical data models are fully attributed, normalized, and included in a data dictionary.
Create data dictionaries for all database efforts that include the following information for each functional data element: the logical data element name, its definition that describes the meaning and the context of the data element in the system, the domain of the data element (the allowable values), the data type, length, and unit of measure.
Assist in developing SOF Enterprise metadata standards and document all meta tags, where applicable, in an XML Schema (XSD file) and post to the Metadata Registry after being vetted through a configuration management process.
Provide consulting services and technical support for database creation, modification, testing, administration, monitoring, tuning, backup, and recovery.
Ensure maximum use of SQL Server Integration Services (SSIS) and SQL Server reporting Services (SSRS) for the integration and delivery of information.
Other related duties as assigned.
Requirements
Bachelors Degree in Computer Science or related area
Minimum of 5 years of relevant experience can replace degree requirement
CompTIA Sec+ Certification Required
Must have high-level written and verbal communication skills
Must have an active SECRET security clearance.
Salary Range: $120,000.00-$129,000.00
Plateau does not accept unsolicited resumes from third-party recruiters without a signed third-party agreement. Any unsolicited third-party resumes forwarded by recruiters to Plateau or to any of our managers or employees will be considered public information, may be treated as a direct application from the person identified in the resume, and will not be eligible for placement fee payment to the agency.
EOE Statement:
Plateau is an equal opportunity/affirmative action employer; all qualified applicants will receive consideration for employment without regard to age, gender, gender identification, sex, sexual orientation, color, race, creed, national origin, religion, marital status, parental status, citizenship status, ancestry, physical or mental disability, genetic information, veteran status, military status, or any other classification protected by federal, state, or local laws.
Plateau is committed to providing access and reasonable accommodations for individuals with disabilities. If you require reasonable accommodation, please email the Plateau HR Department at hrteam@plateauinc.com
Plateau is a proud Equal Opportunity Employer! (M/F/Disability/Vets)
Database Analyst Programmer - Intermediate
San Diego, CA.
Description
The Senior Database Analyst/Programmer will analyze requirements and design, code, test, debug and document custom or framework-based front-end script and markup language under the general supervision of the Project Manager.
Duties and responsibilities
Collaborate with end users to identify needs and opportunities for improved data Design, create, maintain, and manage Enterprise Data Warehouses (EDW), data lakes, data marts, Operational Data Stores (ODS), Extract Transform Load (ETL) solutions, XML, indexes, T-SQL and data manipulation scripts, stored procedures, views, functions, reports and forms.
Apply DoD data standards to all software applications and database data elements, ensuring logical data models are fully attributed, normalized, and included in a data dictionary.
Create data dictionaries for all database efforts that include the following information for each functional data element: the logical data element name, its definition that describes the meaning and the context of the data element in the system, the domain of the data element (the allowable values), the data type, length, and unit of measure.
Assist in developing SOF Enterprise metadata standards and document all meta tags, where applicable, in an XML Schema (XSD file) and post to the Metadata Registry after being vetted through a configuration management process.
Provide consulting services and technical support for database creation, modification, testing, administration, monitoring, tuning, backup, and recovery.
Ensure maximum use of SQL Server Integration Services (SSIS) and SQL Server reporting Services (SSRS) for the integration and delivery of information.
Other related duties as assigned.
Requirements
Bachelors Degree in Computer Science or related area
Minimum of 5 years of relevant experience can replace degree requirement
CompTIA Sec+ Certification Required
Must have high-level written and verbal communication skills
Must have an active SECRET security clearance.
Salary Range: $120,000.00-$129,000.00
Plateau does not accept unsolicited resumes from third-party recruiters without a signed third-party agreement. Any unsolicited third-party resumes forwarded by recruiters to Plateau or to any of our managers or employees will be considered public information, may be treated as a direct application from the person identified in the resume, and will not be eligible for placement fee payment to the agency.
EOE Statement:
Plateau is an equal opportunity/affirmative action employer; all qualified applicants will receive consideration for employment without regard to age, gender, gender identification, sex, sexual orientation, color, race, creed, national origin, religion, marital status, parental status, citizenship status, ancestry, physical or mental disability, genetic information, veteran status, military status, or any other classification protected by federal, state, or local laws.
Plateau is committed to providing access and reasonable accommodations for individuals with disabilities. If you require reasonable accommodation, please email the Plateau HR Department at hrteam@plateauinc.com
Plateau is a proud Equal Opportunity Employer! (M/F/Disability/Vets)
group id: 10430343
