Job Description
Job Title: Database Administrator with BI Development
Location: Rancho Cordova, CA (Hybrid)
Contract role
Job Summary: The individual will be 80% supporting BI development and 20% DBA critical activities.
Responsibility:
- Partner closely with upstream application teams and developers to ensure data sources are accurate, available, and timely.
- Efficiently and accurately develop complex SQL queries (stored procedures, views, and functions).
- Collaborate with front end business intelligence developers and analysts to test, clean, and standardize data to meet the business requirements.
- Responsible for detailed documentation of database structures, configurations, and procedures is essential for maintaining a well-managed database environment through functional specs and document repository.
- Designing the structure of new databases, including tables, relationships, and data integrity constraints, to ensure optimal performance and efficiency, including 3rd Normal Form i.e. normalization\denormalization as appropriate.
- Proactively monitor server, database, and query performance.
- Fine-tune query, database, and server performance as needed.
- Make sure all access is provisioned through database roles and address instances not compliant.
- Regular database backup maintenance and retention according to backup and retention policy.
- Monitor agent jobs and troubleshoot when issues arise.
- Monitor SSIS package runs and first level of troubleshooting when issues arise in SSIS/SQL.
- Manage access through periodic audits and ensure users have correct access on the server.
- Have the confidence to work cross-functionally with various organizations including business stakeholders and technical partners to exchange ideas to meet business requirements.
- Must have excellent verbal communications skills and documentation skills to maintain workflow and query functionality.
- Adhere to Agile SCRUM methodology and processes..
Minimum Qualifications:
- Leverage SQL and SSIS for interacting with SQL server data models included but not limited to an understanding of data connectors and dimensional modeling, tables and queries.
- Experience working with large and complex data sets and able to write complex queries to create stored procedures, views, and functions.
- Empirical understanding of data systems (BI analytics, data blending, data warehousing, data ELT, etc.) on process automation and standardization.
- Experience working in a support team environment by documenting, researching, and solving problems through the service help desk ticketing system.
- Experience working directly with business analysts or business sponsors to gather and validate functional requirements and provide the design specifications.
- SQL server administration.
- SQL server - management, monitoring, and performance tuning.
- Experience managing OLAP and OLTP databases.
- Create, manage, and troubleshoot agent jobs.
- SSIS - create, maintain, and troubleshoot packages.
- SQL - ability to query system and user databases, analyze query plans, propose and implement performance optimization through schema and query optimization, and optimize indexes.
- Ability to work on multiple projects and flexibility to change priorities when needed.
- A 4-year degree in MIS (Management Information Systems), Information Technology, or Computer Science.
- 5+ years minimum experience as a BI SQL Developer and/or a database administrator
- The individual will be 80% supporting BI development and 20% DBA critical activities.
Job Tags
Contract work,