Senior Engineer- IT support Mac equipment

Role: Oracle DBA Developer

Location: Hyderabad

Required Experience: 8 + Years

Skills : DBA, Terraform, Ansible, Python, Shell Script, DevOps activities, Oracle DBA, SQL server, Cassandra, Oracle sql/plsql, MySQL/Oracle/MSSql/Mongo/Cassandra, Security measure configuration

cid:[email protected]

Roles and Responsibilities:

1. 8+ years of hands-on DBA experience in one or many of the following: SQL Server, Oracle, Cassandra

2. DBA experience in a SRE environment will be an advantage.

3. Experience in Automation/building databases by providing self-service tools. analyze and implement solutions for database administration (e.g., backups, performance tuning, Troubleshooting, Capacity planning)

4. Analyze solutions and implement best practices for cloud database and their components.

5. Build and enhance tooling, automation, and CI/CD workflows (Jenkins etc.) that provide safe self-service capabilities to th6. Implement proactive monitoring and alerting to detect issues before they impact users. Use a metrics-driven approach to identify and root cause performance and scalability bottlenecks in the system.

7. Work on automation of database infrastructure and help engineering succeed by providing self-service tools.

8. Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata)

9. Monitor database performance, control access permissions and privileges, capacity planning, implement changes and apply new patches and versions when required.

10. Recommend query and schema changes to optimize the performance of database queries.

11. Have experience with cloud-based environments (OCI, AWS, Azure) as well as On-Premises.

12. Have experience with cloud database such as SQL server, Oracle, Cassandra

13. Have experience with infrastructure automation and configuration management (Jira, Confluence, Ansible, Gitlab, Terraform)

14. Have excellent written and verbal English communication skills.

15. Planning, managing, and scaling of data stores to ensure a business’ complex data requirements are met and it can easily access its data in a fast, reliable, and safe manner.

16. Ensures the quality of orchestration and integration of tools needed to support daily operations by patching together existing infrastructure with cloud solutions and additional data infrastructures.

17. Data Security and protecting the data through rigorous testing of backup and recovery processes and frequently auditing well-regulated security procedures.

18. use software and tooling to automate manual tasks and enable engineers to move fast without the concern of losing data during their experiments.

19. service level objectives (SLOs), risk analysis to determine which problems to address and which problems to automate.

20. Bachelor's Degree in a technical discipline required.

21. DBA Certifications required: Oracle, SQLServer, Cassandra (2 or more)

21. Cloud, DevOps certifications will be an advantage.

Must have Skills:

Ø Oracle DBA with development

Ø SQL

Ø Devops tools

Ø Cassandra

OJ Commerce Inc. is a fast-growing retailer serving the US market through OJ Commerce.com and various market places such as Amazon, Walmart, and eBay. OJ Commerce is a privately held, profitable company headquartered in Miami, Florida, USA with a 100% dedicated back-office in Chennai. The workhours are flexible with predominantly India business hours with some overlap with US Eastern Time business hours based on need.

Experience: 

4+ relevant experience

Role: Individual Contributor Role.

Location : Chennai - Ekaduthangal (Work From Office)

Skill Sets:

• In-depth knowledge in MS SQL Server and related tools & technologies such as SSIS, SSRS &SSAS

• Exposure to data modelling and ability to develop complex queries & procedures

• Manage and monitor performance, capacity and security of the database

• Continuously improve the performance of the database in alliance with the Database Adminstrator by optimizing jobs, procedures & queries

Desirable Skills:

➢ Candidates with experience in ecommerce / online retail is added value.

➢ Should be comfortable in dealing with senior leadership (internal & external)

➢ Communication Skills – Excellent verbal and written communication skills with ability to explain ideas very clearly.

➢ Self–motivated and flexible, with an ability to work independently.

Traits Expected: 

• Ability to work in a fast–paced, dynamic environment with limited resources

• Problem-solver with a desire to solve complex business problems with innovative & cost–effective solutions

• Excellent analytical and problem-solving skills, with out–of–the–box thinking.

Location: Chennai

Experience: 4 years

ABOUT US

Established in 2009, Ashnik is a leading open source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

THE POSITION

Ashnik is looking for talented and passionate people to be part of technical support team. You will be responsible for solving technical problems to ensure uptime. You will assist customers with their technical issues and questions around specific technology, including configuration and tuning and performance. Successful candidate should understand the importance of ownership of the problem and way to get it solved by leveraging the team in given time.

RESPONSIBILITIES

• Be the First point of contact for support queries
• Be responsible for solving customer queries and tickets in timely manner.
• Communicate with customer and internal team regarding problems reported and solved status in timely and effective manner.
• Log monitoring, event monitoring and resolving tickets in defined SLA.
• Apply updates and patches to keep the software up-to-date in line with organizational policies
• Provide support for installation and configuration.
• Monitor and identify areas of performance improvement
• Identify and write scripts for automating support tasks.
• Communicate effectively internally and with product support team to reproduce, resolve support cases and document them.

ESSENTIAL SKILLS

• Hands-On experience and skills in Linux operating system
• Knowledge of ELK stack or relevant technologies such as SolaR, Splunk etc.
• Good understanding of Indices Mapping , Index management such as archiving, reindexing, sharding etc.
• Good understanding of Analytical data structure and experience in deployment of same in the form of Reports and Dashboards
• Experience in NoSQL or RDBMS technology is desirable
• Python/Node.js or relevant data processing programming experience is preferred.
• Knowledge of Designing and Developing data pipeline using ETL tool such as Elastic Stack.
• Knowledge of real-time data collection with various data sources.
• Experience in deploying scalable Elastic cluster is desirable

QUALIFICATION AND EXPERIENCE

• 2 -4 years of experience in technical support role.
• At least 2+ years experience working across multi-cultural and geographically distributed teams
• Experience in trouble shooting, maintaining and supporting production setup
• Engineering or equivalent degree
• Ability to interact effectively with customers for problem resolution.
• Sense of urgency and ownership to get problems solved in timely manner
• Attention to details.
• Ability to work on multiple tickets/ support cases effectively and to be able to manage the time critical tasks.

LOCATION: Bangalore

Experience: Minimum 2 yrs

Package: upto 8 LPA

Database Administrator (DBA)

EDUCATION,EXPERIENCE REQUIRED:

BE/MCA/ B.TECH / BCA

Exp -  Min 4 yrs  

CTC – Upto 12 LPA

Job Description:

1. Installing, Configuring, Managing, Monitoring and troubleshooting SQL Server 2005/2008/2008R2/2012/2014/2016
2. Database administration activities like Installation, Configuration, Backup & Recovery, and Database Security.
3. Providing availability solutions like Mirroring, Log Shipping, Replication and Always on.
4. Database Up gradation and Migration
5. Ensure performance monitoring, backup, restore, and security recovery solutions.
6. Troubleshooting expertise in SQL server issues under production environment.
7. Handling the entire production servers with skills and understanding client's requirement Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
8. Automating process by creating jobs, and error reporting using Alerts by SQL Server Agent.
9. Backup and Recovery strategy, Database Refreshes.
10. Creation and maintenance of Databases, creating Roles and managing user permissions.
11. Setting up, trouble shooting and maintenance of production server databases.
12. Providing Production support for Database and Applications.
13. SQL Server store procedure, functions, View, Index and trigger development.

 

Job requirement:

1. Deep understanding of OS and its management including kernel space management
2. Experience with Linux servers in virtualized environments
3. Experience installing, configuring, and maintaining services such as Bind, Apache, MySQL, Nginx, etc.
4. Experience in Monitoring tools like Nagios.
5. Familiarity with load balancing, firewalls, etc.
6. Proficient with network tools such as iptables, Linux IPVS, HA Proxy, etc.
7. Experience with virtualization technologies, such as Xen KVM and VMware.
8. Ability to build and monitor services on production servers

Job Functions / Responsibilities:

• Find technical resolutions on issues or queries related to unknown or new scenarios
• Meet cases resolution SLA"s
• Manage relationships with clients
• Work with cross-functional teams as and when required
• Keep up to date with all eCW products and their enhancements
• Maintain excellent customer satisfaction level
• Other duties as assigned

Requirements: 

• Proficient with relational databases (MySql, MsSql)
• Knowledge / Experience with Java or C++ (OOPs Concepts)
• Experience with Internet Protocols, HTTP / HTTPs
• Default ports for HTTP / FTP / MYSQL etc
• Experience with Web Application Server(s)
• Understanding of 3 -Tier / N-Tier Architecture
• Knowledge of SQL Server 
• Basic Knowledge of Network Concepts (VPN, Telnet, Ping, Protocols)

Other Skills / Abilities: 

• Telephone etiquette
• Fluency in English Communication.
• Ability to balance multiple priorities
• Strong analytical and problem-solving skills

• Looking only for immediate to 15 days candidate.
• Looking for an experienced Integration specialist with a good expertise in ETL Informatica and a strong Application integration background
• Minimum of 3+ years relevant experience in Informatica MDM required. Powercenter is a core skill set.
• Having experience in a broader Informatica toolset is strongly preferred
• Should prove a very strong implementation experience in Application integration, should demonstrate expertise/presentation with multiple use cases
• Passionate coders with a strong Application development background, years of experience could range from 5+ to 15+
• Should have application development experience outside of ETL, (just learning ETL as a tool is not enough), experience in writing application outside of ETL will bring in more value
• Strong database skills with a strong understanding of data, data quality, data governance, understanding and developing standalone and integrated database layers (sql, packages, functions, performance tuning ), i.e. Expert with a strong integration background who has more application integration background than just an ETL Informatica tool
• Experience in integration with XML/JSON based and heavily involve JMS MQ (read/write)
• Experience in SOAP and REST based API's exchanging both XML and JSON files used for request and response
• Experience with Salesforce.com Integration using Informatica power exchange module is a plus but not needed
• Experience with Informatica MDM as a technology stack that is used for integration of senior market members with Salesforce.com is a plus but not needed,
• Very strong scripting background (C/bourne shell/Perl/Java)
• Should be able to understand JAVA, we do have development around JAVA, i.e ability to work around a solution in programming language like Java when implementation is not possible through ETL
• Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff.