SQl Developer (Job Code : J45093)  

 Job Summary
Share this job on Facebook  Share this job on Twitter  Share this job on Linked In
 
Experience:
4.00 - 8.00  Years 
 
Location:
Hyderabad
 
Designation:
SQl Developer
 
Degree:
BE-Comp/IT, BE-Other, BTech-Comp/IT, BTech-Other, MCA, MSc-Comp/IT
 
Educational Level:
Graduate/Bachelors
 
Stream of Study:
Computer Science/IT
 
Industrial Type:
IT-Software/Software Services
 
Functional Area:
IT Software - Client Server
 
Key Skills:
SQL developer
 
Job Post Date:
2022-06-04 16:23:41  
 
 

 Company Description
 
About Company:
Our cliis an American multinational technology company founded in 1989 by Gary Burrell and Min Kao in Lenexa, Kansas, United States, with headquarters in Olathe, Kansas. Since 2010, the company is incorporated in Schaffhausen, Switzerland.
The company specializes in GPS technology for automotive, aviation, marine, outdoor, and sport activities.
At Garmin, we like to work hard and play hard. It comes easy when you work on cool products with hard-working individuals who share the same passion.
Many exciting things are happening at our client and people are taking notice: Our client was ranked as one of the 500 World’s Best Employers in 2017 and in the top three most reputable tech companies (U.S. Reputation Institute, 2018). More recently our Client was ranked 5th in the list of America’s Best Employers in the large company category and received the highest ranking of any tech company in the list. In 2020 our client was ranked as one of the World`s Best Employers from Forbes

POSITION SUMMARY: Cybersecurity is a fast-paced ever-changing field that results in a very unique, dynamic work environment. Cyber Security Analysts are trained Cyber defenders that are empowered to make high stake decisions based on numerous data sources to enforce and ensure security objectives while enabling and maintaining business operations. The SOC Team provides 24x7x365 support for initial triage and incident response actions as well as actively monitoring the threat landscape for global client

ESSENTIAL FUNCTIONS:

• Utilizes and makes improvements to our clients’s security systems allowing for real-time analysis of security alerts.
• Provides first and second tier support for moderately complex potential security incidents reported by customers.
• Monitors and analyzes the inbound network traffic for suspicious activity and potential cyber security incidents.
• Strives to remain technically current with latest security techniques and trends in the industry that translate to operational action items.
 

 Job Description
 
POSITION SUMMARY: We are looking for SQL developer with knowledge on PostgreSQL database administration, who will be working with development team, to provide technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, optimizing and efficiently managing technology using tools and scripting.


ESSENTIAL FUNCTIONS:
• Participate in application development projects and be responsible for the database modeling, database design, data profiling, and data querying.
• Develop procedures, functions, packages, triggers, collections, indexes, constraints, views, sequences, optimized queries using joins and subqueries in support of application development.
• Responsible for
• SQL performance tuning - Ability to understand execution paths, applying hints and optimizing them.
• ETL using SQL - Extract, transform and Load data in bulk from and to database tables
• Transaction design - Ability to design optimal transactions understanding locking, logging and other requirements.
• Responsible for the monitoring, uptime of all production databases and manage data security and privacy.
• Responsible for regular databases maintenance activities(e.g., Vacuum, Re-indexing, Archiving, Monitoring, alerting, and error analysis on logs).
• Responsible for regular backups and recovery of databases, includes PITR (Point in time recovery) based on the requirement.
• Responsible for Configuring replication setup between Production and DR sites.
• Responsible for applying patches (version upgrades) to PostgreSQL.
• Participate in a 24×7 support and perform other duties as assigned.


EDUCATION EXPERIENCE AND SKILLS REQUIRED:
• Graduated in technical discipline or equivalent professional experience in computer science (BE / B.Tech / M.Tech / MCA / M.Sc) and a minimum of 4 years relevant experience.
• Must have strong analytical, verbal and written communication skills.
• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
• Must have strong knowledge of Linux, CentOS.
• Demonstrates ability to solve moderately complex technical problems independently.
• Experience with application deployment by using CI/CD.
• Experience with Docker deployment

DESIRABLE SKILLS:
• Basic understanding on GIS, spatial database (PostGIS) and queries.
• Knowledge on issue tracking/ticketing systems like Jira, ADO.
• Proficient understanding of code versioning tools such as Git, SVN
• Knowledge on scripting languages like Python, shell scripting (e.g., Bash, Perl)
• Basic knowledge of apache2, nginx, and tools like icinga, munin, ansible, puppet.
• Technical certifications.