SQL Developer/Data Analyst
Opportunity for an experienced SQL Developer/Data Analyst to join a dynamic team and work with other project specialists.
Summary about this job
Database Development & Administration
Company: e&e
Location: Brisbane
Work type: Contract/Temp
Salary: n\a
Phone: +61-2-6948-6861
Fax: +61-8-6021-8056
E-mail: n\a
Site: n\a
Detail information about job SQL Developer/Data Analyst. Terms and conditions vacancy
About e&e
e&e is a professional Business and Technology Consultancy providing services to our clients during business initiation, transformation and IT programs of work. e&e are partners and trusted advisors to some of the largest corporations and institutions across Australia. Our organisation has a strong cultural synergy of likeminded consultants based on mutual respect who strive to achieve professional excellence.
e&e is currently engaged with some of Australia's most exciting ICT projects across a diverse range of industries such as aviation, financial services, resources, mining, healthcare and government sectors. e&e's management team are dedicated to developing and recognizing its staff by providing a dynamic working environment and career progression within an organisation that is innovative and continuing to experience growth across Australia.
The Opportunity
We currently have an opportunity within our organisation as a consultant SQL Developer/ Data Analyst from a strong mining background to join our highly-skilled team. You will play a key role on a data migration package of work. This will involve in-depth data analysis, development of data standards and recommendations on the required solution moving forward.
To join our team, you will demonstrate:
· Knowledge of the mining industry is essential
· Modify and adapt complex Transact-SQL stored procedures to work with new table structures
· Use tools like SQL Profiler for database tuning. Generate traces and make performance recommendations
· Identify performance issues, deadlocks/contention and resolve them.
· Manage production, QA and development database environments.
· Create detailed documentation for tables and stored procedures
· Able to comprehensively test the application against the original version using automation where appropriate.
· Learn relevant business processes and understand the data flow, criticality and dependencies.
· Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
· Attend meetings as and when directed, planning meetings, safety meetings, progress & status update meetings and other stakeholder meetings.
· Conduct technical risk analysis of the proposed solutions and alternatives.
· Undertake site inductions and safety training where applicable.
· Able to work autonomously and own the outcome.
· Able to modify the design as new requirements or constraints are identified.
· Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
· Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
· Knowledge of Oracle PL/SQL stored procedures.
· Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
· Ability to create and maintain detailed stored procedure and database related documents.
This is an excellent opportunity to work with cutting edge technologies with a team of professionals that are specialists in their chosen fields. To find out more about this engagement please send your resume to [email protected] with REF #1366.