Brian Leblanc Email & Phone Number

Edmonton, Alberta

Comprehensive database management. Oracle Database Security Products Team management.Manage Oracle license compliance. Continuous improvement.Team reviews and redesign of processes or procedures on an ongoing basis to deliver improved service to clients.Technical leader and mentor.

Functional responsibility: Oracle Database/Server/Application performance tuning. Perform technical and business analysis in support of application performance requirements for several key business clients. Additional responsibilities include: Supported IT application development teams with problem resolution.Managed Oracle/Application software version control. Capacity planning - server and disk storage recommendations.New product/release evaluation and recommendations. Knowledge transfer/training client support teams on application and Oracle daily operations.Interface with customer/end user, including efficient response in trouble shooting and problem solving of application performance and database problems using SQL Navigator, Oracle Enterprise Manager, Oracle Tracer, Statspack.Project team member and Performance Analyst - Compiled results documentation in support of performance testing and provide stakeholder recommendations to meet business needs.Managed coordination and planning for internal servers and disk storage in support of the performance group. Project Management:Tier 1 Telco implementation project: Managed Oracle database and billing applications for 24/7 production environment. Recruit new employees for INTEC DBAs and developers as required.Mentor INTEC Bangalore resources: knowledge transfer, training/ongoing support.

Functional responsibility: Performed and supported Oracle database design/ installation (platforms (HP,Sun,AIX)/ upgrades along with data modeling according to physical/functional specifications and compile supporting documentation accordingly. Analyze/support and recommend proper sizing and configuration for client databases based on volumes and growth forecasts. Administration and management of development, training and testing team’s databases.Conducted analysis and provided recommendations on new releases. Plan execution of the new database designs and determine the physical data and data structure changes necessary to implement new functionality.Provide leadership and guidance to support/developments teams and deal with escalated issuesProject Management:Led successful migration for client from existing legacy system to new Oracle based billing software, allowing client to provide continued billing service to their customers. Involved in detail business and data analysis, design / development of conversion tools and on-time implementation. Three months onsite at AT&T London for Client conversion - DB and application support for major upgrade release One month onsite eBay – San Francisco, California Client implementation project – installation of software, knowledge transfer, troubleshooting, operation training, installation of 3rd party tools, create databases, recommend Oracle database parameters, file layout, sizing, performance tuning Design/development of conversion tools used for legacy AS400 to Oracle PL/SQL billing systemOn-site client conversion projects in San Francisco CA and Monterrey Mexico

Functional responsibility: Oracle Database and SQL tuning. Identify and resolve performance bottlenecks using such tools as Oracle trace, Oracle Enterprise manager, Middleware monitoring software and Unix OS tools. Optimized Oracle data file layout using available resources and hardware configurationDeveloped performance/benchmarking reportsTuning recommendation reports on production environments

Functional responsibility: Responsible for all coding according to physical or functional specifications or build and deliver software, ensuring functionality within scope of expertise and business need. Programming languages include: C,C++, Unix, PL/SQL, Peal, and Java. Assisted in writing the physical and functional specifications for project componentsAssisted with systems analysis /design and compiled test cases for own component of project.Involved in all stages of the product life cycle up to and including testing - unit, system and UAT support

Diploma (Honors), Computer Systems Technology; System Development And Computer Programming

Education record