Manages the Design, develop, and implement SQL database instances for the development and production environments in AWS. Manages the Cloud environments for USAP EDW Team and implements BI Database solutions for USAP. Is skilled and experienced in technical Design and Development of BI data warehouses. Competent in AWS Redshift database management and performance tuning. Has experience in supporting SSIS, SSRS, PowerBI and SQL in the delivery of BI solutions. Creativity in problem solving and strong verbal/written communication skills will be leveraged in this role.
● Work with EDW ETL/BI developers, Business Analysts and QA team members to understand database requirements, implement solutions and to provide comprehensive Cloud DBA Services to USAP.
● Design, develop, and implement SQL database instances for the development and production environments in AWS
● Performance tuning
● DB usage monitoring
● Network monitoring
● Setup new instances
● Monitor Cloud costs
● Assists in the optimization of the EDW and Data Mart’s
● erform and assist in the design and extension of data marts, meta data, and data models
● Participates as required in the project efforts to develop the next generation USAP EDW and Data Marts
● Migrate application date from on-prem databases to Cloud databases
● Monitor and maintain database security and database software
● Experienced with DMS (Database Migration Services) Tools to migrate data from On-premises to Cloud.
● Daily maintenance, monitoring, problem resolution and internal customer for production and dev support
● On-call for production databases
● Test, validate and implement performance and resource optimization improvements in consultation with AWS development Teams
● Database & Application (SQL Server & AWS Redshift) performance tuning
● Root cause analysis of production-related database issues
● DB security setup
● Bachelor’s degree required with major/concentration in relevant information technology area (CS, MIS, CIS or CE).
Any Graduate