.. 10-15 years Job Location - Gurgaon Client - Renewable Energy Firm Responsibilities: ● Develop, implement, and maintain a comprehensive Quality Management System across the energy supply chain, covering procurement, manufacturing, logistics, and distribution processes. ● Ensure adherence to relevant .. read more
Location- Gurgaon/ Bangalore Experience- 7Yrs-8 Yrs Job Summary Looking for a versatile professional to join our team in the role of Hybrid Data Engineer and Database Administrator. This position requires a blend of expertise in Data Engineering and Database Administration, with a strong foundation in Oracle DBA roles and a demonstrated transition into data engineering. The ideal candidate will possess hands-on experience with database systems such as Oracle, Postgres, Teradata, or Starburst (Trino) in an AWS environment, coupled with proficiency in utilizing Git, Jenkins, and Terraform. Additionally, broader AWS experience including S3, Lambda, VPC, and Security Groups would be highly advantageous. Responsibilities: possess hands-on experience in working on some of the relational and non-relational databases (Oracle/SQL Server/DB2/PostgreSQL/MySQL/Golden Gate/Data Guard) on AWS and/or on-prem infrastructure. years’ Experience with AWS Services like AWS RDS, Aurora, EC2, S3, DMS, AWS Backups, and DynamoDB. years’ Experience with the Design and deployment of Amazon Machine Images (AMI) for Database. in database migrations from on-prem to AWS Cloud, replication technologies like Oracle Golden Gate/HVR and maintain database systems to ensure optimal performance, reliability, and security. develop, and deploy data pipelines and ETL processes for efficient data ingestion, transformation, and analysis. with cross-functional teams to understand data requirements and develop scalable data solutions. database performance metrics and proactively address any performance or scalability issues. version control for database scripts and configurations using Git. Jenkins for continuous integration and deployment of database changes. infrastructure provisioning and configuration using Terraform to enhance deployment efficiency. AWS services such as S3, Lambda, VPC, and Security Groups to support data infrastructure. guidance on database security best practices, including access control and encryption. updated on emerging technologies and industry trends in data engineering and database administration. Required Qualifications: Years industry implementation experience with Data Engineering tools. experience of working within AWS and must be capable of working from infrastructure (VPC, EC2, Security groups, S3 etc.) to AWS data platforms (Redshift, RDS, Glue etc). In depth experience of Azure/GCP is also of interest. with database migrations to AWS Cloud deploy and support databases on Ec2, AWS RDS and VMware platform Knowledge of infrastructure automation with Terraform. of source control management and associated tools such as Git. and maintain database systems to ensure optimal performance, reliability, and security. develop, and deploy data pipelines and ETL processes for efficient data ingestion, transformation, and analysis. with cross-functional teams to understand data requirements and develop scalable data solutions. database performance metrics and proactively address any performance or scalability issues. version control for database scripts and configurations using Git. Jenkins for continuous integration and deployment of database changes. infrastructure provisioning and configuration using Terraform to enhance deployment efficiency. AWS services such as S3, Lambda, VPC, and Security Groups to support data infrastructure. guidance on database security best practices, including access control and encryption. updated on emerging technologies and industry trends in data engineering and database administration. years of management experience required years consulting experience preferred degree or equivalent experience, master's degree Preferred data warehousing, OLTP systems, data integration and SDLC and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.) of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data. of on premises and cloud infrastructure architectures (e.g. AWS, Azure, GCP) Preferred Skills & Experience: experience in Oracle DBA roles, with a solid understanding of database management principles. in at least one of the following database systems: Oracle, Postgres, Teradata, or Starburst (Trino). experience with Git, Jenkins, and Terraform for version control and automation. with AWS cloud services, particularly in an environment involving S3, Lambda, VPC, and Security Groups. analytical and problem-solving skills with a proactive approach to troubleshooting. communication and collaboration abilities, with a track record of working effectively in cross-functional teams. and working experience with Data Integration processes, such as Data Warehousing, EAI, etc. to analyze business requirements as they relate to the data movement and transformation processes, research, evaluation and recommendation of alternative solutions. to provide technical direction to other team members including contractors and employees. to contribute to conceptual data modelling sessions to accurately define business processes, independently of data structures and then combine the two together. ability to serve as a trusted advisor that builds influence with client management beyond simply EDM. create documentation and presentations such that they “stand on their own” on experience with AWS Products (e.g. AWS Lambda, AWS Glue, AWS EMR, AWS S3, AWS Sage maker, etc.) building, operationalizing, securing, and monitoring data processing systems on AWS Cloud Platform contribute to internal/external Data Integration proof of concepts. ability to create new and innovative solutions to problems previously not encountered. to work independently on projects as well as collaborate effectively across teams team building, interpersonal, analytical, problem identification and resolution skills working with multi-level business communities effectively utilize SQL and/or available BI tool to validate/elaborate business rules. influences and, at times, oversees business and data analysis activities to ensure sufficient understanding and quality of data. effectively with all team members and builds strong working relationships/support with them. Understands modern data warehouse concepts (real-time, cloud, Big Data) and how to enable such capabilities from a reporting and analytic standpoint.