Sr. Database Engineer

New Yesterday

Primary Responsibilities:- Maintain the DB2 LUW Database platform from Infrastructure side.- Design and implement strategies to migrate on-prem Database platforms to cloud.- Make recommendations for new database technologies or options for existing databases.- Build the foundation for a successful production deployment for new technologies.- Work for the data warehouse team whose responsibilities are:- Maintaining on-premise and cloud-based data warehouse platforms.- Work with business and application developers to design, modify, and tune database schemas.- Implement and maintain the database design in development environment.- Assist developers with complex query tuning in a high transaction volume, mission-critical data center environment.- Refine and automate regular processes, track issues, and document changes.- Maintain the data definition repository.- Performance monitoring, change implementation, backup and recovery, privilege maintenance, user maintenance, new database setup, educating user base, troubleshooting user :1.3+ years of experience as DB2 LUW DBA.2.1+ years of experience using DB2 Data Partitioning Feature (DPF).3.3+ years of experience with Unix shell scripting.4.3+ years of hands-on Unix/Linux and systems administration skills as it relates to databases.5.3+ years of system trouble-shooting , responsible and delivery focused.
Nice to Have:- Experience working with Database platforms such Hadoop, Snowflake, AWS, Azure.- Experience with Python. - Experience with AWS based data warehouse platforms and tools such as Lake Formation, S3, Redshift, RDS, Athena, Glue, Lambda, Secret Manager, VPC, Quicksight and SageMaker.- Experience with Terraform.- General knowledge of OLAP databases.- Experience with file system, volume management, storage concepts (SAN).- Database security
Location:
Alpharetta