Mysql dba

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

• Experience in design and architecture.
• Sales cloud and service cloud expertise.
• Multi brand, and associated security model is a key problem statement.
• Channel integration using LWC is also a big topic of design discussions
• Telco knowledge,TMF

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

• Job Title:- Microsoft Tech Lead
• Location:- CG Road, Ahmedabad(Mobile and flexible), WFH is available, sometime you have to come attend business meetings
• Education:- No bar in Education
• Desired Skills:- ASP.Net, C#, Database Design, MySQL, MSSQL, Bootstrap, SQL Server
• Experience: - 05 yrs. to 06 yrs.
• Number of Vacancy:- 01
• Job Timing:- Flexible Time
• Interview Process: - 2 round, First round is Telephonic, Second round is face to face only.

Job Description

Responsibilities:-

• Plan, lead and deliver the software development cycle.
• Lead technical team and solve their day to day issues.
• The successful candidate would lead a team of 6-10 developers.
• Handle ongoing projects as well as new projects.
• Guide or mentor new team members and existing members.

Skills Requirement

• Experience in Microsoft ASP, C#, SQL server, MS SQL, Bootstrap, database design and github.

Who can Apply

• Education : No bar
• Experience : Good to have: BFSI domain and professional certification

• The opportunity to take on some of the world’s most meaningful challenges, helping customers achieve clean water, safe food, abundant energy, and healthy environments
• The ability to make an impact and shape your career with a company that is passionate about growth
• The support of an organization that believes it is vital to include and engage diverse people, perspectives, and ideas to achieve our best
• Thrive in a company that values sustainability, drives a safety-focused culture, and has been recognized as one of the most ethical companies in the world
• Comprehensive benefits package starting day 1 of employment- medical, dental, vision, matching 401k, company-paid pension, stock purchase plan, tuition reimbursement, and more!

What You Will Do:

• Gather and process raw data at scale (including writing scripts, web scraping, calling APIs, write SQL queries, manage PI data, etc.).
• Devise and deploy the core automated processes that pre-process, clean, and present the required data for further processing.
• Develop and implement standard quality checks/algorithms and continuously improve upon these in collaboration with software and marketing teams.
• Develop and deploy metrics, dashboards, and visualizations characterizing both individual accounts and corporate enterprises in analytically insightful and visually compelling ways
• Apply engineering knowledge in developing data-driven algorithms for anomaly detection, failure prediction, and optimization.
• Work closely with our field sales, marketing, and industry technical consultants to configure data aggregation and visualization platforms and sustain those platforms over time.
• Process unstructured data into a form suitable for analysis – and then do the analysis.
• Support business decisions with ad hoc analysis as needed. Work closely with the leadership team to create dashboards (such as Power BI) to drive agile decision-making.
• To develop prototypes and proof of concepts for the selected solutions.
• Work with our customers to develop data exchange technologies

Minimum Qualifications:

• Education: B.S. (Masters’ preferred) in Computer Engineering, Applied Mathematics, Engineering, Information Technology or any other technology-related field. An equivalent of this educational requirement in working experience is also acceptable.
• Candidates must have 2 – 5 years of experience working as a PI Developer and/or PI System Manager, in a fast-paced environment and complex business setting.
• Knowledge in: Excel macros & JSON for our Refined Knowledge & CrudeFlex applications, PI AF templates, and PI Cloud Connect, PI WebAPI, C# to send data from OSIsoft PI to Microsoft SQL, APIs and web programming, Python or R languages
• The candidate must have a demonstrated experience in building and maintaining reliable and scalable ETL on big data platforms as well as experience working with varied forms of data infrastructure inclusive of relational databases such as Microsoft SQL (on-prem & Azure), Oracle, & OSIsoft PI.
• The PI Developer must further have exceptional skills in SQL server reporting services, analysis services, Salesforce, integration services, Power BI, or any other data visualization tools.

Preferred Qualifications:

• Experience in analytics in the oil & gas industry is a plus.
• Experience in the Microsoft Azure stack including data factories, data gateways, & Power BI.  Experience in PI Integrator for Business Analytics is desirable.  Experience in Hadoop, Spark and other analytic technologies is a plus. Digital-enabled technology experience and passion.
• Communication Skills: Excellent communication skills in both verbal and written form. The PI Developer works closely with other functional teams in the CDS organization.  Communication skills are also imperative for the PI Developer in his collaborative role where he will have to interact cross-functionally with non-technical departments. To enable effective collaborations, the PI Developer will have an exceptional ability to convey complex messages in a clear, simplified, and understandable manner. The candidate will also be required to draft reports and prepare presentations for Director – Commercial Digital Solutions (CDS) and Director – CDS Operation. These reports and presentations must be clear, concise, unambiguous, engaging, and convincing, which will demand exceptional communication skills on the PI Developer’s part.
• Microsoft Office/Software: A candidate for this position must be highly proficient in the use of MS Word, MS Excel, PowerPoint, and Outlook, which will all be necessary for the creation of both visually and verbally engaging reports and presentations, for leadership.
• Interpersonal Skills: The PI Developer will be a result-driven individual, be passionate and a self-starter, be proactive requiring minimal supervision, be highly organized, have an ability to handle multiple tasks and meet tight deadlines, be a creative and strategic thinker, work comfortably in a collaborative setting, work comfortably with senior departmental leadership, and demonstrate an ability to remain calm during times of uncertainty and stress, inspiring the same in his team.
• People Skill: The candidate must be a people person who is able to form strong, meaningful, and lasting connections with others, enabling smooth and continued collaborative relationships, earning him the trust, and gaining the confidence of the Director – CDS Operation team, and other team members across the company.

We are looking for  4+ years of experience as a Cloud Engineer or Administrator able to demonstrate in-depth knowledge of the cloud computing market, enterprise, and open-source technologies.

- Azure AZ-104 Certified Azure Administrator, AWS  Certification or GCP Professional Certification required

 Advanced scripting (Bash, PowerShell, Python) .E
experience in automation, configuration, etc. Ideally has experience with Puppet, Chef, Ansible, or equivalent.

 Container technologies (Kubernetes, Rancher, Docker, CoreOS)

 Experience in support and configuration of systems and application monitoring services (CloudWatch, Prometheus, StackDriver, Azure Monitor)

 Experience with cloud management and governance technologies (CloudHealth, CloudCheckr)

Experience using, and configuring ITSM systems (Zendesk, ServiceNow)

Familiarity with running mission-critical infrastructure within 24x7 production environment

Cloud Platform Developer:

• 8 to 12 years of platform development experience with good knowledge on any virtualized platform (VMware ESXi, Linux KVM, Openstack, AWS, etc)
• Candidate must understand how to instantiate/provision/package VMs on cloud platforms – OVF/OVA, qcow2, etc.
• Strong in Shell and Python scripting; Knowledge of Apache Maven is plus.
• Knowledge of Ansible or Terraform will be useful
• Knowledge of Rift.io / Open source MANO / Restful APIs will be plus
• Good knowledge of Linux OS fundamentals – IPCs (sockets, shared memory, etc), multi-threading, Semaphores, IP routing, etc.
• Experience of working in an agile software development environment is critical
• Exposure to multiple aspect of product lifecycle process including requirement gathering, functional specification, design, development, testing, and maintenance.