SQL Job Vacancies in Pune

DATA SCIENTIST - GUROBI OPTIMIZATIONPune6-13 Years 10-21 LPA Notice: Up to 30 DaysWe are looking for experienced Data Scientists with strong hands-on Python, SQL and Gurobi optimisation experience.This requirement is specifically for professionals who have worked on mathematical optimisation using Gurobi and can apply their expertise to real-world data science/optimisation problems.MUST-HAVE SKILLSPython SQL Gurobi Mathematical / Optimization ModellingExperience: 6-13 YearsCTC: 10-21 LPALocations: Hyderabad, Bangalore, Chennai or PuneNotice Period: Immediate / Serving / Up to 30 days preferredWHAT WE ARE LOOKING FORYour profile should demonstrate:- Strong hands-on Python experience- Good working knowledge of SQL- Practical experience with Gurobi optimisation- Experience developing and solving optimisation models- Ability to work with data and translate business problems into optimisation solutionsThis is a specialised requirement. Candidates with general Python/Data Science experience but without hands-on Gurobi optimisation experience may not be relevant.BEFORE YOU APPLYPlease check the 10-21 LPA CTC range and make sure your preferred location is one of:Hyderabad Bangalore Chennai PuneIf you have 6-13 years of experience and your recent work includes Python, SQL and Gurobi optimisation, we would like to hear from you.Please share your Updated CV + Current CTC + Expected CTC + Notice Period + Current Location + Years of Gurobi Experience + Python Experience + LinkedIn Profile.ADI HR & ConsultingConnecting the right expertise with the right opportunity.#DataScience #DataScientist #Gurobi #Optimization #MathematicalOptimization #PythonJobs #SQLJobs #DataScienceJobs #HyderabadJobs #BangaloreJobs #ChennaiJobs #PuneJobs #TechJobs #ADIHRConsulting

Key ResponsibilitiesAdminister and support AWSbased data platforms across development test staging and production environmentsManage services such as Amazon S3 Redshift RDSAurora Glue EMR Athena Lake Formation Kinesis Lambda DMS Step Functions and CloudWatchProvision and configure cloud resources using infrastructureascode tools such as Terraform AWS CloudFormation or AWS CDKImplement identity and access controls using IAM roles policies permission boundaries AWS Organizations and service control policiesMonitor platform health capacity job execution data pipelines storage and query performance proactively identify and resolve issuesPerform incident problem change release and servicerequest management in accordance with defined SLAs and ITIL practicesOptimize Redshift clusters SparkEMR workloads storage tiers data transfer and compute consumption for performance and costImplement backup recovery highavailability businesscontinuity and disasterrecovery controls conduct periodic restoration and failover testsSecure data using encryption key management private networking secrets management logging vulnerability remediation and leastprivilege accessEnable data governance through cataloging lineage classification access auditing retention and lifecyclemanagement controlsBuild operational automation using Python Shell scripting AWS CLI SDKs and CICD pipelinesMaintain platform standards runbooks architecture diagrams configuration records SOPs troubleshooting guides and audit evidencePartner with data engineers architects security teams application teams FinOps and business stakeholders on onboarding migrations upgrades and capacity planningProvide technical leadership mentor junior administrators coordinate vendor support and drive rootcause analysis and continuous improvementRequired Technical SkillsStrong handson administration experience with AWS data analytics compute storage networking security and monitoring servicesDeep understanding of data lake data warehouse lakehouse batchprocessing and streaming architecturesExperience administering Amazon Redshift including workload management query tuning distribution and sort strategies scaling snapshots and securityExperience with AWS Glue Data Catalog crawlers jobs workflows and Lake Formation permissionsWorking knowledge of Apache Spark and Amazon EMR administration troubleshooting scaling and performance tuningStrong knowledge of Amazon S3 design bucket policies lifecycle rules versioning replication encryption and access controlsProficiency in IAM KMS Secrets Manager VPC security groups private endpoints CloudTrail CloudWatch AWS Config and GuardDutyExperience with Terraform or CloudFormation and CICD tools such as AWS CodePipeline Jenkins GitHub Actions Azure DevOps or GitLab CICDProficiency in Python and Shell scripting for administration monitoring deployment and remediation automationStrong SQL skills and familiarity with relational databases data modeling ETLELT patterns and data integrationKnowledge of observability log analytics ing backup disaster recovery patching and productionsupport practicesUnderstanding of cloud costmanagement practices tagging standards budgets usage analysis and rightsizingQualificationsBachelors degree in Computer Science Information Technology Engineering or a related discipline7 years of overall experience in cloud infrastructure data platform administration database administration or data engineering operationsAt least 4 years of handson experience supporting AWS environments including production data and analytics workloadsDemonstrated experience operating highly available secure and scalable enterprise platformsStrong troubleshooting rootcause analysis documentation communication and stakeholdermanagement skillsAbility to participate in oncall support and planned maintenance activities when requiredSkillsMandatory Skills : AWS EC2, AWS Glue, AWS Lambda, AWS S3Good to Have Skills : AWS Well Architected ToolsRemote