I am a SQL Server DBA Manager and my employer (Symantec) will be
opening a position in the near future (20-60 days) for my DBA team.
Here is the job description:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sr Security Infrastructure Adm
Calgary, Canada
Consulting
Job Duties
Senior Infrastructure Database Administrator will work as part of a
DBA team that provides 24x7 support of all technical aspects MS SQL
Server in a 100+ server enterprise environment. Primary support and
duties are performed during standard business hours, however 24 hour
on-call support during off hours and weekends is required on a
rotation schedule.
The production environment is an OLTP 1000+ distributed database
system, consisting of databases ranging in size from small-medium to
VLDBs (>400 gig). DBA responsibilities include:
· Automation of MS SQL Server maintenance and alerting.
· Implement and maintain database security.
· Monitor failed and long running MS SQL Server jobs.
· Monitor, tune, and analyze database performance and allocate server
resources to achieve optimum database performance.
· Support and maintenance of MS SQL Server Log Shipping.
· Support and maintenance of MS SQL Server Transactional Replication.
· Setup new MS SQL Server instances and databases.
· Documentation of MS SQL Server system environment, setup,
maintenance and standards.
· Capacity planning of MS SQL Servers.
· Work closely with technically savvy users and developer to resolve
database production problems.
Requirements
Education and training:
Symantec's managed security service is seeking an experienced
candidate with a minimum of 3 years experience administering MS SQL
Server. Bachelors in Computer Science or similar Engineering Degree;
can substitute 4-6 years of experience in the IT field. Must have
knowledge of MS SQL Sever best practices. MCSE/MCDBA is desirable.
Required Skills:
· Strong understanding of major components of MS SQL Server
architecture.
· Hands on experience with SQL Enterprise Manager, Query Analyzer,
Profiler, Data Transformation Services.
· Strong experience in database Backup, Restore and Recovery
procedures.
· Strong SQL programming skills including, developing & testing T-SQL
stored procedures & queries.
· Strong understanding of relational database modeling and design.
· Experience in tuning and analyzing SQL Server databases for
performance.
· Performance monitoring experience using Windows Performance Monitor
and MS SQL Server Profiler.
· Candidates must have excellent trouble shooting skills.
· Other Skills:
Ability to work both independently and as a part of a team.
Strong desire and passion to learn new technologies.
Fluent in English language good written and verbal skills.
Good problem solving and documentation skills.
Ability to perform challenging assignments under general supervision.
Demonstrated commitment to quality.
Desirable/bonus Skills (for additional consideration):
· Knowledge of Windows 2000 operating systems and SQL server in a
clustered environment are advantageous.
· Knowledge of Dimensional modeling and OLAP services in a data
warehousing environment is a plus.
· Knowledge of networking and systems security.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
We are flexible on some of the jobs requirements (e.g. years
experience). If one has solid MS SQL Server skills (depth of
knowledge) and a decent command of the English language your have meet
the minimal requirements.
If you are interested send me an email at:
se*********@monitoredsecurity.com or sp*******@hotmail.com.
Recruiters please do not contact me.
Thanks,
Sean Powell
