NUSTAR TECHNOLOGIES INDIA PRIVATE
This listing was posted on hirist.
Database Engineer - Site Reliability (5-8 yrs) Chennai (DevOps)
Location:
Chennai
Description:
Job Description :- 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.- DB Cluster management.Chennai - 5-8 years (ref:hirist.tech)
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to hirist
Important Safety Tips
- Always meet the employer in person.
- Avoid sharing sensitive personal and financial information.
- Avoid employment offers that require a deposit or investment.
To learn more, visit the Safety Center or click here to report this listing.
More About this Listing: Database Engineer - Site Reliability (5-8 yrs) Chennai (DevOps)
Database Engineer - Site Reliability (5-8 yrs) Chennai (DevOps) is a Engineering Engineer Job at Nustar Technologies India located in India. Find other listings like Database Engineer - Site Reliability (5-8 yrs) Chennai (DevOps) by searching Oodle for Engineering Engineer Jobs.
Database Engineer - Site Reliability (5-8 yrs) Chennai (DevOps) is a Engineering Engineer Job at Nustar Technologies India located in India. Find other listings like Database Engineer - Site Reliability (5-8 yrs) Chennai (DevOps) by searching Oodle for Engineering Engineer Jobs.