Find work in the United States.

A simpler way to find your next job.

Jobs in the United States

Save this search

Added 5 days ago
CO
Dept Systems Analyst/Programmer III
City of Scottsdale
Scottsdale, AZ
- $93,974.4 to $126,900.8 USD / year
This position performs advanced professional-level systems analysis, configuring, scripting and SQL development, implementation, and maintenance of information systems supporting the City…
Added 5 days ago
Manager, Data Integration
VNS Health
New York, NY
Creates end-to-end ETL solutions involving Informatica workflows and mappings, Oracle PL/SQL procedures and functions, and Unix shell scripting to load VNS Health data from disparate source…
Added 5 days ago
Software Engineer
John Deere
MILAN
Added 5 days ago
PW
Research Scientist 4 (Health Informatics)
People With Developmental Disabilities, Office for
Schenectady, NY
- $111,708 to $137,590 USD / year
· Experience with statistical software packages such as SAS, R, and/or SQL (SAS experience preferred).
Added 5 days ago
Lead Business Analyst - Marketing & Finance Applications
Vail Resorts
Remote, United States
…stakeholder communication. Take part in the on-call rotation. Use SQL extensively to investigate issues, analyze data anomalies and validate…
Added 5 days ago
Solution Architect, Lead
Booz Allen Hamilton_United States
McLean, VA
Experience with federal IT stack platforms such as Databricks, Palantir, Oracle, SAP, .NET, SQL Server, Azure, or AWS GovCloud
Added 5 days ago
Cloud Engineer
Booz Allen Hamilton_United States
Colorado Springs, CO
Experience creating scripts in SQL and Python to automate tasks
Added 5 days ago
Lead Software Engineer: Frontend Development
JPMC page
Palo Alto, CA · Columbus, OH
Strong experience building and maintaining web applications with full stack with Python, Django, Java, JavaScript, Node React, Next-JS and SQL
Added 5 days ago
Lead Software Engineer - Java / Post Trade Technology
JPMC page
Jersey City, NJ
Demonstrate experience in messaging platforms (Apache Kafka or equivalent), No SQL DB's (like Mongo DB & Redis)
Added 5 days ago
Technical Services Manager
Military Spouse Jobs & VetJobs
United States
Added 5 days ago
Transportation Analyst
Miebach
Fishers, IN · Dallas, TX
Advanced Excel skills; experience with SQL, Python, Power BI, Tableau, or similar tools is preferred
Added 5 days ago
Lead OSINT & Data Analyst
The MITRE Corporation
Bethesda, MD
Experience with SQL, Python, geospatial analysis, data visualization, or analysis of structured and unstructured data.
Added 5 days ago
Portal Administrator (Active Secret Clearance required)
CompQsoft Inc. - ACTIVE
Remote, United States
…highly beneficial. You will also utilize your knowledge of SQL in SQL Server, authentication protocols like Kerberos, and web server technologies such as Apache and NetWeaver. Exposure to…
Added 5 days ago
CI
SAP Middleware Developer
CompQsoft, Inc.
Aberdeen Proving Ground (APG), MD
- $160,000 to $180,000 USD / year
The SAP Middleware Developer is responsible for the maintenance, enhancement, support, and administration of SAP Process Integration (PI) interfaces and associated middleware technologies.…
Added 5 days ago
Customs & Trade Data Analyst
Avnet US
Tempe, AZ
Added 5 days ago
Java Full Stack Developer - Vice President
DB USA Core Corporation
NY
…across major dealer-to-client platforms. As a Java Full Stack Developer, you will develop and enhance the core pre-trade technology that supports the Rates Flow business, using modern React…
Added 5 days ago
Developer II, Software Web Development, Full Stack Developer
Red River
Remote, United States
Red River is seeking a talented Full Stack Developer to support an existing project in Sacramento, CA.
Added 5 days ago
Data Visualization and Reporting
CACI
Chantilly, VA · Chantilly
…and development skills. They will have expertise in Tableau, SQL, Python, Excel and PowerPoint, and experience with HR data. They will be self-motivated and results-oriented, who can work…
Added 5 days ago
Senior Manager, Talent Analytics & Assessment Science
The P&G Company
United States
Experience with Power BI, R, Python, SQL, or related analytics and visualization tools.
Added 5 days ago
TP
Intern, Talent Analytics & Assessment Science
The P&G Company
United States
- $61 USD / hour
Experience with statistical programming, data visualization, or tools such as R, Python, SQL, or Power BI.
Added 5 days ago
Marketing Analytics Manager (Remote)
Purple Innovation LLC
Remote, United States
Advanced proficiency in SQL and Microsoft Excel.
Added 5 days ago
CS
Data Scientist 3 - MLOps
Captivation Software
Annapolis Junction, MD
- $130,000 to $270,000 USD / year
…extract this information from a variety of data formats (e.g., SQL tables, structured metadata, network…
Added 5 days ago
OA
Data Scientist
Other Agencies and Independent Organizations
Washington, DC
- $143,913 to $187,093 USD / year
…analyzing specialized data sets. | Codes in Python or R and uses SQL and other data processing/analytics tools to analyze data sets, and uses visualization tools like Power BI, Tableau,…
Added 5 days ago
Sr. SQL Database Administrator I (6893)
MetroStar
Washington, DC
As a Sr. SQL Database Administrator I, you’ll join a collaborative, high-performing team responsible for designing, maintaining, securing, and optimizing mission-critical database…
Added 5 days ago
SVP, Head of Corporate Digital Analytics & Insights
U.S. Bank National Association
San Francisco, CA

Closed listing

Smith Johnson Tech

16326 - Database Administrator 4

Lansing, MI, United States

This opening has closed.

The original listing is kept below for reference.

Find open jobs More jobs with this employer

About employer

Job details

Experience: 12+ years of experience
Posting language: English

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

Work Model Hybrid, 2 days a week on site Allows Relocation YES, if local will interview in person

SUMMARY

This position supports the Center for Educational Performance and Information (CEPI) database environment primary for the Statewide Longitudinal Data System (SLDS) modernization with the Common Education Data Standards (CEDS).

The database environment includes:

Multiple SQL Server instances
Multiple Collection Environments (Development, Quality Assurance/Testing, Pre-Release, and Production)
Numerous SQL Reporting Services Servers
35+ collection databases
100+ analysis databases

This position is the Subject Matter Expert (SME) for the CEPI SLDS data warehouse and requires considerable independent judgment directing and coordinating the appropriate data administration and management methods, practices, procedures and tools, to complete the required assignments. Expertise is required in Microsoft SQL Server database support, and professional knowledge on CEDS standard. This position is heavily involved with strategic and tactical information design, the analysis of business areas, security, and data modeling to meet data collection needs and the transition of ETL process from on premise to cloud servers. Responsibility includes the identification, analysis, categorizing, synthesis, design, and productive use of business information. In addition, this position is responsible for enforcing/ensuring that the architectural frameworks are properly implemented and enforced, monitoring and upgrading the server infrastructure that supports the database environment.

RESPONSIBILITIES

Designs, implements, and continuously expands/maintains data pipelines by performing extraction, transformation, and loading activities. Responsible for data preparation jobs, data analysis and data reporting. Performs technical troubleshooting, root cause analysis and provides technical expertise for ETL jobs. Collaborates with developers. business and other team members to design and deliver correct high-quality data and to provide advice and support.
Responsible for data analysis and database management. Involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Knowledge of the utilities and production tools used for data storage management to support the Application Team. Coordinates physical changes to computer databases; codes, tests, and implements physical database, applying knowledge of data base management system.
Establishes physical database parameters. Uses structured query language (SQL) to define database objects using database definition language (DDL) and control access to database objects using data control language (DCL). Tests and corrects errors and refines changes to database.
Enters SQL to create production data base. Uses database utility programs and 3rd party utilities to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of data base changes on other systems.
Evaluates users' requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance. Coordinates the use of data to ensure data integrity and control redundancy, loads databases, and reorganizes as needed. Performs data modeling and prototyping. Responsible for the development of ETLs. Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models. Performs security recovery procedures.
Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures. Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems.

QUALIFICATIONS

Required:

12+ years of experience
Azure Database services
SQL Data Modeling/structure
Extensive ETL development experience
TSQL: 8-10 years
ETL development: 6-8 years
PowerShell: 5 years
Azure DevOps: 5 years
Scrum: 5 years
Bachelor’s degree

MANAGER NOTES

Must be available to interview in person
Clear and concise written and verbal communication is crucial to success and productivity in this role

PRE-EMPLOYEMENT & CLIENT SUBMISSION REQUIREMENTS

Employment and/or client submission is contingent upon successful completion of required pre-employment screening and verification processes. These requirements include:

• Background check: Candidates must successfully complete the required background screening in accordance with company policy and applicable law.

• Drug screening: Candidates must successfully complete the required drug screening in accordance with company policy, applicable client requirements, and applicable law.

• Identity and location verification: Candidates may be required to complete identity and/or location verification using a secure verification tool prior to client submission.

• Employment eligibility: Candidates must provide appropriate documentation to verify employment eligibility as required by law.

• Qualification verification: Information provided during the application and recruiting process, including employment history, education, certifications, licenses, and professional references, may be verified as applicable.

• Additional client requirements: Additional screening, documentation, or verification may be required based on the client, position, work location, or applicable requirements.

All screening and verification activities will be conducted in accordance with applicable company policies, client requirements, and federal, state, and local laws.

BENEFITS

This is a contract opportunity with a great organization. As a contractor for Smith Johnson, you are eligible for medical, dental, life, disability. Smith Johnson pays for 70% of your medical and dental and 100% of life and disability. The contract is also eligible for PTO/holiday accrued monthly. You are also eligible for a 3% retirement matching plan. Smith Johnson believes in taking care of our contractors.

About employer

More about this job

Skills

Microsoft SQL Server
Quality assurance
SQL
Reporting
Data modelling
Data analysis
Troubleshooting
Root cause analysis
Data engineering
Data storage
DDL
Data models
Implement ICT recovery system
Microsoft Azure
Microsoft PowerShell
DevOps
Scrum
Communication skills
Documentation
Recruitment

Report this job