Description
An Excellent Opportunity has arisen for a SQL DBA to join an experienced, passionate team working on Market leading projects with a Leading Australian Organisation based in Canberra. Not only is this a truly innovative and challenging environment but it is also highly regarded as an excellent work environment offering outstanding career growth opportunities, training, bonuses and benefits.
Key Responsibilities:
- The successful applicant will join a large team that specialises in developing tailored billing and reporting solutions for large customers within a Datawarehouse environment.
- As a Development SQL DBA, you will be required to work as a part of Database Development team to maintain the SQL Server in the development and test environment.
- Analysing complex customer problems and requirements and develop appropriate solutions.
- Maintain SQL Server in the Development and Test environment which include installation, configure, apply up to date service packs, organise security and user permission.
- Deploy database changes mainly using Team Foundation Server and configure environmental events.
- Advice environmental issues for production deployment as part of deployment process.
- Restore and backup different databases, scheduling, keep up to date maintenance plan.
- Find and tuning database performance issues and advice developers accordingly.
- Work as part of a team committed to the development, maintain and deploy using SQL Server and Team Foundation Server.
- Development and review other developers code to make sure business requirements, technical specification and specified coding standards are meet.
- Focus on developing code which can be reused in order to minimise rework.
Key Requirements:
- 5+ years development experience with SQL Server 2005 or upper version.
- Experience working with as a DBA supporting Microsoft SQL Server 2005, 2008 within a corporate environment.
- Experience working with Transact SQL, Stored Procedures, SSIS Package, Data Transformation Services, SQL Profiler and SQL Execution Plan.
- Proven database administration (DBA) experience in MS SQL Server; including installation and setup of SQL Server instances, keep update with latest service packs.
- Experience working with SQL Server database backup/restore, scheduling, maintenance plan and recover the database in different stage.
- Advance understanding of Database Engine and other components of SQL Server. Well understanding the performance issue and different tools/way to tuning to handle large volume of data.
- Experience working with T-SQL programming, writing Stored Procedure, Triggers and Views.
- A good understanding about SQL Server architecture and functionality of different components like Database Engine, Analysis Services, Integration Services.
- A good understanding about Datawarehouse concept including ETL process and Reporting Services.
- A clear understanding of SSIS package architecture, different execution and deployment processes.
- Working Experience with SQL Server Service Broker and Reporting Service.
- Basic understanding about new features of SQL Server 2012.Qualifications.
- Microsoft Certification in SQL Server trace is highly desirable.
* MUST HAVE AUSTRALIAN WORKING RIGHTS - PR will be considered.
Excellent long term career opportunity with LATEST TECHNOLOGIES IN THE MARKET! Please send your C.V. to Natalie Zegarelli (IT Infrastructure - Commerce) or call me for professional and confidential assistance. If you are interested in this position please apply to Natalie Zegarelli quoting reference number 19/ZENN.