Dear Consultant,
Hiring Data Base Technical Lead/Manager-6-9Yrs, up to 50LPA Hyderabad; (3CBARC5E3SIUM/DATABASETL69Y50LH)
Submit CV hr@3dindiagroup.com then must fill job application form.
Note: Short NP
Note: JD Posting NOT allowed; if we have come to know account will be blocked
Salary Information MUST not be disclosed
Source Only CTC>30LPA form TIER 1 University Only
No Poach: JPMC
Job Details
Experience 6 - 9 Years
Annual Salary 50 LPA (Including Variable) INR
Work Location
Hyderabad, Andhra Pradesh, India
Domain
Information technology (IT)
Job Description
• Design and implement robust database engineering/administration solutions including
• experimenting with technologies like SQL SERVER, PostgreSQL, database resource
• management, security, backup and recovery, performance monitoring and tuning, data
• management and capacity planning, planning, and implementing failover between
• database instances.
• Develop database architectural strategies at the modelling, design and implementation stages to address business or industry requirements.
• Conceptualize and enforce database development standards.·
• Implementation of Database Clusters, AlwaysOn Setup, troubleshooting, Partitioning and·
• Performance Optimization on SQL Server/PostgreSQL.
• Analyze the resource utilization trends and come up with strategy to assure stability and·
HA of production systems.
• Capacity planning· & system-level architecture in accordance with business projected
• volumes and infrastructure capacity
• OS/Storage/DB configuration and optimization·
• Plan and install upgrades of database management system software to enhance database· performance.
• Designing and Documenting a new SQL Infrastructure based on requirements gathered·
• (Performance/Capacity/DR/Business Continuity/Etc.)
• Design databases to support business applications, ensuring system scalability, security,·
• performance and reliability.
• Work with application architects, system engineers, business analysts and others to·
• understand business or industry requirements and design the database accordingly.
• Monitoring and tuning of existing databases and related parameters like, Table space·
• utilization, CPU utilization, Hard Disk Utilization, Memory utilization, and alert log file.
• Leading, coordinating and participating in key process improvements as they relate to the·
• database environment.
• Work with existing Database Reliability engineering team in 24x5 shift model and weekend·
• on-call on rotational basis.
• What you'll need:
• Minimum 8 years on SQL database design and administration experience (8+ years on·
• SQL Server with Minimum 5 years database architecture experience.
• Hands-On Experience with SQL Server/PostgreSQL Administration (backup/recovery,·
• tuning, disaster recovery, migration) and write PostgreSQL Code.
• Performance tuning and query optimization experience on SQL·
• Server/PostgreSQL/Amazon Aurora.
• Hands-on experience with related/complementary software platforms and languages (e.g.·
• Python and PowerShell)
• Analyze resource utilization trends and come up with strategies to assure stability and·
• reliability of production systems.
• Provide meaningful inputs for capacity planning which eventually helps with cost·
• optimization for OS, storage, and database.
• Design and develop meaningful SLI (Service Level Indicators) and SLO (Service Level·
• Objective) dashboards for practical alert mechanism.
• Minimum 6 years of hands-on technical leadership experience in designing, modelling and·
• implementing large data sets with relational database systems preferably MS SQL Server.
• Must have experience in handling large-scale multi-terabyte database architectures.·
• Experience working on AWS (Amazon Web Services) or equivalent Cloud platform.·
• Managing databases on Cloud, Migration, Scaling up databases on Cloud.
• Must understand the SQL Server architecture at a 200-300 level·
• Familiarity/experience on Site Reliability engineering practices like managing Incident·
• management/response, managing overload, practical alerting, effective troubleshooting,
• Non-abstract large system design and data processing pipelines.
• Strong understanding of database licensing schemes. Ability to develop TCO models and·
• assess business impacts, ROI etc. highly desirable.
• Understanding of how AWS Cost Per Resources Work and helping in designing Cost·
• Dashboards for Resource utilization.
• Experience with databases, such as PostgreSQL, Amazon RDS and Amazon Aurora·
|
0 Comments