Database SRE

About the job
Serve as the primary subject matter expert on database technologies and architectures.
Collaborate with development teams to design and implement database schemas and structures.
Provide guidance on database performance tuning and optimization strategies.
Conduct thorough analysis of database systems to identify areas for improvement and implement solutions.
Develop and enforce database standards, policies, and procedures.
Evaluate and recommend new database technologies and tools to enhance efficiency and scalability.
Mentor junior team members and provide training on database-related topics.
Troubleshoot complex database issues and provide timely resolution.
On-call help to monitor and manage uptime, end-to-end performance and operability of all service processes and dependent infrastructure to meet SLAs. Understand and meet the scale, capacity, security, performance attributes, and requirements of the service and technology stack.
Designed and developed ETL solutions through analysis of business objectives.
Tuned existing packages/tables/queries for faster ETL processing.
Developed and administered reporting and application development database (Microsoft SQL Server) following a strict set of normalization standards.
Designed, implemented, and maintained new and existing databases using Microsoft SQL Server
Participated in process improvement teams to identify and improve database development processes and optimize performance of existing data structures.
Designed physical and logical database for the core application and provided required database development support to the development team.
Developed various Oracle PL/SQL programs for rating services to help investors perform efficient credit risk-driven investment analysis.
Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions/enhancement on oracle application. 
Performed optimization of reports using multitude of SSRS report optimization techniques at report level and query database level.
Designed business analysis and management statistical reports using SSRS utility. 
Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process.
Increased efficiency and quality of reports by coordinating and implementing solutions using knowledge of database design and report design.
Worked closely with operations/project managers to gather reporting requirements and define BI metrics to gauge project success.
Provide expertise and information knowledge management to design reporting approaches using BI software products. 
Worked with business units to identify and prioritize needed corrections and enhancements to the Operational Data Warehouse and reporting architecture.
Worked as a back-end developer to support company data warehouse applications that maintain the company subscriptions data.
Created logical and physical data models for new requirements after discussion with technical team and application users as per agile methodology.
Designed and optimized conceptual and logical dimensional data models for data marts to support reporting infrastructure.
Use Power BI and SSRS to create reports and dashboards to monitor processes.
Power BI with custom SQL query data sources. 
Assisted in data analysis, star schema data modeling and design specific to data warehousing and business intelligence environment.
Worked on relational database projects for Blood Center of Iowa - Participated in business requirement analysis and data analysis.
Develop intricate database update programming to enforce business rules using database objects and scripts.
Defined query optimization, performance and tuning of stored procedures and database objects.
Listener configuration support.