smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.
Responsibilities
- Perform regular Database administration tasks.
- Perform HA and DR setup maintenance tasks
- Analyze the performance metrics and provide tuning recommendations
- Analyze the repetitive support requests and provide the automation feasibility
- Handle incidents and problems
- Perform trend analysis of the incidents/events and help in finding the resolution
Skills & Experience
- Strong experience in Database Administration in Oracle database
- Have strong knowledge on Oracle SQL and PL/SQL
- Expertise in writing and analysing Stored procedure , packages and triggers.
- Exposure to AWS Cloud RDS is required
- Experience in Database Patching/Upgrade/Migrations
- Experience in managing the HA and DR setups ( Standby, DataGuard)
- Experience in performance tuning ,query optimisation
- Experience with client interaction is preferred
- Exposure to other MySQL database is preferred
- Excellent written and verbal communication skills.
- Real time experience in DB administration (Installation/Tablespace Management/Object Management
- Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
- Experience in Database Patching/Upgrade/Migrations
- Knowledge on GoldenGate is desirable
- Knowledge on Oracle 12C/19C new features
- Experience with client interaction is preferred
- Knowledge on RAC & ASM is desirable
- Exposure to AWS Cloud is desirable
- Excellent written and verbal communication skills
About smartShift Technologies
Similar jobs
Role : Oracle ERP consultant
Experience: 4-8 years
Involves L3 support and Development activities.
Good at Work Order Management, Item/Bill of materials, Quality Assurance, Order Management
#HiringAlert
We are looking " Oracle APEX " for Reputed Client @ Permanent Role.
Must Have Skills:
1.Experience in Oracle APEX, SQL / PLSQL concepts, collections, function, procedure, package and types - Mandatory
2. Experience in JASPER / OBIEE reports
Good To Have Skills:
1.Knowledge in Oracle Forms and Reports, JavaScript, HTML, CSS or any other web-based programming language is added advantage (Optional)
2.Key Responsibilities: Design develop test and implement features and code using Oracle Application Express APEX
3. Perform requirements analysis development design test and deployment of custom Oracle applications.
4. Writing SQL queries Views Materialized views PLSQL procedures functions packages triggers cursors collections Ref cursor cursor variables System reference cursor Dynamic SQL
5. Debug code and maintain PL SQL procedures and functions.
6.Optimize existing applications and scripts for both usability and performance.
7. Adherence to policies processes and procedures within your areas of responsibility
8.Evaluate new features and technologies overseeing their implementation into the environment as appropriate.
9.Ability to prioritize, manage, deliver and report on multiple projects simultaneously highly motivated and able to work against aggressive deadlines schedules.
Professional Attributes:
1. Ability to work with minimal supervision.
2. Exhibits strong ethics, positive attitude, and calm demeanor under pressure.
3. Flexible, organized and possesses the ability to work in a fast-paced environment.
Location : Chennai
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
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
Application development:
Development of forms and reports.
Creation of SQL packages, functions and procedures etc.
Should have extensively worked on oracle EBS implementation/ upgrade/ support projects/ tools JIRA.
- 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)
Good in customization and development of CRM module
Should have good knowledge in Unix/ Shell Scripting (UNIX)
Should have good knowledge in the PLSQL & Oracle
Should have Basic knowledge in Corporate / Institutional Banking, Trade Finance, Payments, Loans and Retail areas.
Technical :-
Finacle Scripting, Finacle Reporting Tool (FINRPT), CRM customization
Finacle Integrator (FI), JSP/JS
Profile Required
Overall 5+ years of experience required in Finacle Development
Good banking experience
Strong analytical skills
Strong hold on oral & written communication
Experience in Finacle application
Ability to identify and escalate issues, keep managers and peers well informed on a recurrent basis
Able to work in high pressure environment
Highly motivated and team oriented
Key Responsibilities & Job Duties
● To provide functional support for our ERP
Finance applications (Oracle eBusiness Suite)
○ Assist users in case of question
○ Manage functional requests
● Train users to keep the right level of skill
○ To organize audits of the use of systems
○ Detect and collect issues
○ Implement action plan and coordinate actions
● To manage enhancements in accordance with the procedures which apply in the department
○ Collect enhancements from users
○ Challenge the user requirements
● Define priorities
○ Write functional specifications and coordinate developments with the technical team
● Test and train the users
○ Regularly communicate to the users the status of the enhancement
○ Report activity to the management
○ Collaborate with functional support in other zones to share information
○ Optionally, may manage some projects
Key Technical & Functional Competencies
● Functional competencies
○ Strong Business processes: Finance
● Technical competencies
○ Good Knowledge of Oracle SQL
○ Strong Oracle eBusiness Suite
Modules: AP, AR, GL, FA (At least at a professional for two Modules)
○ Basic knowledge of Oracle eBusiness Suite Modules: INV, PO, OE, WSH is preferable
- Writing queries used for front- end applications (websites, desktop applications)
- Designing and coding database tables to store the application data
.- Data modeling to visualize database structure.
- Reviewing query performance and optimizing code.
Required:
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills
Nice to have:
1) Experience in SAP BO / Crystal report / SSRS / Power BI
2) Experience in Informix
3) Experience in ETL
Responsibilities:
• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another
Experience in PLSQL OR PL/SQL OR Oracle
SQL Server