Associate Technical Consultant- Database
Company – Appnomic Systems
Location – Bangalore
Status – Full Time, Employee
Job Category – Computers, Software
Relevant Work Experience – 4-7 Years
Career Level – Experienced- Individual Contributor
Education Level – BE from T1 Colleges
The successful candidate will have a joint responsibility for operational product service, product delivery and engineering for Database technologies.
Experience in following:
RDBMS – Query and Server tuning capability in one of the data base servers such as MySQL, MSSQL Oracle, Sybase, DB2.
Experienced in various environments: OLTP, RAC, Exadata.
Extensively worked on back end programming using PL/SQL, Stored Procedures, Functions, Packages, Database Triggers for Oracle 12c/11g/10g.
Strong knowledge in Oracle Cursor management, Exception Handling and also experience in performance tuning of SQL queries using SQL Trace, Explain Plan, TKPROF, Indexing, Hints.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Transportable table spaces.
Strong experience in performing root cause analysis of Oracle database performance bottleneck by using AWR, ADDM and ASH
Experience in non-relational distributed database management system like NoSQL, Cassandra would be an added advantage.
Expert level knowledge in minimum two OS (Windows, Linux, AIX, Solaris, HPUX )
Ability to write on demand scripts in the field using any one of these Perl, Python, Shell Script.
Able to suggest / recommend which KPIs to watch for among the commonly used, App Servers, Database Servers, Messaging Engines, and storage.
Familiar with Application performance debugging tools
Should be self-motivated, willing to work with small teams and coordinate with other product teams.
Should be able to independently carry on tasks with limited supervision.
Excellent written and verbal communication skills.
Bachelor’s Degree in Engineering (Computer Science, Electronics) and above, Or
Master’s Degree in Computer Applications (MCA) from premier top institutions.
Should come from development background and should have participated in software development life cycle at least for one large enterprise class application.
Should be part of product implementation/delivery team and should understand challenges in rolling out enterprise class products.
Minimum of 3 years in core software development
Minimum of 2 years’ experience in product implementation/roll out.
Oracle, MSSQL Server & MySQL SQL programming
Data lifecycle management
Scripting in Perl, Shell Script, Expect
At least two of Linux, AIX, Solaris, HPUX, Windows platforms experience.
Understanding of operating system concepts and networking protocols.