Senior Database Engineer
Senior Database Engineer12
Applications
12
Applications
Hyderabad
Full-Time
Senior: 8 to 12 years
₹ 15L - ₹ 22L (Per Year)
Posted on Aug 15 2024
About the Job
Skills
Database Management
SQL Query Optimization
Data Modeling
Database Performance Tuning
ETL Processes
Database Security
Backup and Recovery
Database Replication
Sr. Database Engineer
Required Work From Office ( Hyderabad )
Experience: 8 to 12 years would be preferable.
Willing to Join within * 7 days
Required Skills:
- Good knowledge of databases like PostgreSQL (preferably cloud-hosted), with strong programming experience in SQL. Cloud-hosted (AWS, GCP, Azure, and data warehouse ( Snowflake, Azure, Synapse)
- Strong understanding of and practical working experience with Data warehouse (incl. Cloud-based DW like Snowflake and Azure Synapse), ODS, and Data marts.
- Competence in data preparation and/or ETL tools like snapLogic, MATILLION, Azure Data Factory, AWS Glue, and SSIS (preferably good exposure in one or more) to build and maintain data pipelines and flows.
- Good knowledge of databases, stored procedures, and optimizations of huge data
- In-depth knowledge of ingestion techniques, data cleaning, de-dupe, and partitioning.
- Experience with building the infrastructure required for data ingestion and analytics
- Ability to fine-tune report-generating queries
- Solid understanding of normalization and denormalization of data, database exception handling, transactions, profiling queries, performance counters, debugging, database & query optimization techniques
- Understanding of index design and performance-tuning techniques
- Familiarity with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions
- Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting
- Adhere to standards for all databases e.g., Data Models, Data Architecture, and Naming Conventions
- Exposure to Source control like GIT, Azure DevOps
- Understanding of Agile methodologies (Scrum, Kanban)
- Understanding of data modeling techniques and working knowledge of OLTP and OLAP systems
- Preferably experience with NoSQL database to migrate data into another type of database with real-time replication. (desirable)
- Programming language experience or exposure in Golang, Python, and shells scripts (bash/zsh, grep/sed/awk, etc..) (desirable)
- Experience with CI/CD automation tools (desirable)
Personal Attributes:
- Very good communication skills.
- Ability to easily fit into a distributed development team.
- Ability to manage timelines of multiple initiatives.
- Ability to articulate insights from the data and help business teams make decisions
- Able to work with ambiguous requirements, seek clarity around uncertainty, and manage risks
- Ability to communicate complex concepts to non-data audiences
About the company
For over 25+ years Prudent Technologies & Consulting has been helping customers secure the technical and functional resources needed to deliver mission-critical IT & Business initiatives. What started as an IT Consulting company providing premium IT services in the US, UK, Europe, and India, has grown to include full-service IT Consulting specialty practices in four key technology verticals: Data ...Show More
For over 25+ years Prudent Technologies & Consulting has been helping customers secure the technical and functional resources needed to deliver mission-critical IT & Business initiatives. What started as an IT Consulting company providing premium IT services in the US, UK, Europe, and India, has grown to include full-service IT Consulting specialty practices in four key technology verticals: Data Sciences, Cybersecurity, App Dev, and Enterprise CRM. Prudent’s specialty practices are built on strong partnerships with best-of-breed technology firms, including Salesforce, Splunk, Microsoft, and Databricks.
At Prudent we pride ourselves on our ability to tailor the best solution to meet our customer’s needs. From augmenting an IT team with a qualified consultant to delivering an end-to-end software solution, our goal is always to help our customers execute critical business and IT initiatives.
We are always on the lookout for innovators! We strive to hire the best people to work on our exciting projects and teams. We offer our staff a great compensation package, work-life balance, benefits, 401K, holidays, PTO, career paths, teamwork, awards & recognition, and much more.
Come join the Prudent family and let’s have fun creating innovative solutions for our clients!
Reach out to us.
Career inquiries: Career.info@prudentconsulting.com
Business inquiries: Info@prudentconsulting.com ...Show Less
Industry
Information Technology & ...
Company Size
501-1000 Employees
Headquarter
Hyderabad, Telangana
Other open jobs from PRUDENT GLOBALTECH SOLUTIONS PRIVATE LIMITED