- Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Database Administrator 2.
Urgent! Database Administrator 2 Job Opening In Vancouver Washington – Now Hiring First Tek, Inc.
POSITION RESPONSIBILITIES
Note: All official drafts, documents and recommendations, as listed below, must be reviewed, finalized and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.
Create complex stored procedures from user requirements
Provide performance tuning for SQL stored procedures
Mine the data from various databases used to support BPA Transmission Operations and provide the results in the form of custom reports to various customers within Transmission Operations.
Required reporting includes routine processes that are able to be reused by various customers and other situations that are a one-off and require a quick report to be created to address a specific need (i.e. response to on-site auditors).
Provide Federal Information Security Management Act (FISMA) and North American Electric Reliability Corporation critical infrastructure protection (NERC CIP) related activities associated with database security and management, per established processes, including:
Administration and support of:
Enterprise level SQL Server 2019 and later
MySQL 5.x and later
Windows Server 2016 and later
Data Analysis and Design
Automation using PowerShell, WMI, SMO and .Net
Remote server monitoring
Reporting:
Requirements gathering
Report creation and customization
Develop and document approved processes and procedures
Compliance with all applicable regulations (FISMA, NERC-CIP, NIST, BPA, etc.)
Analyze the Windows Server and/or DBMS and CCN environment for processing and performance tuning.
Recommend required system modifications, develop and provide implementation plans.
Provide developer and end-user support for databases including maintaining existing views and procedures, performance tuning, and troubleshooting database problems as needed.
Provide Windows Server support for users including maintaining privileges, installing applications, performance tuning, and troubleshooting problems as needed.
Recommend effective consolidation strategies.
Participate in project and/or technical meetings as requested to provide technical recommendations from a DBA perspective on the risks, impacts and strategies related to process and project decisions.
Communicate with a wide variety of technical and business experts in both individual and group settings using email, self-generated documentation and presentations.
Maintain filing system(s), files, emails and records in accordance with compliance requirements.
File and disperse documents/letters only to appropriate personnel.
Maintain all official records in accordance with the Information Governance & Lifecycle Management (IGLM) and Information Security (INFOSEC) standards and procedures.
Validate official records are accurately maintained for auditing purposes.
REQUIREMENTS
Education & Corresponding Experience (required on matrix)
Bachelor's Degree in Information Technology or a directly-related technical field is preferred.
Level 2:
5 years of experience is required with an Applicable Bachelor's Degree in applicable fields.
7 years of experience is required with an Applicable Associate's Degree in applicable fields.
9 years of experience is required without a degree.
Experience must include direct work experience in Computer/Information technology performing Database Administration.
Required Technical Skills & Experience (required on matrix)
4 years of experience with SQL Server or My SQL:
DBMS installation and patching
Backup and recovery
Monitoring
Patching
Performance Tuning
Security
Mirroring/Always On/Cluster Management
Reporting SQL Server
Reporting Services
Report Builder
Business Intelligence Design Studio
Integration Services
Crystal Reports
Preferred Skills & Experience (optional on matrix)
SQL Server and Database Administration
Certified Microsoft SQL Server 2008 or later and/or MySQL 5.x or equivalent DBA experience desired
Microsoft SQL sqlcmd, bcp, etc.
MySQL MySQL, MySQLAdmin, MySQLDump is considered a strong plus,
OLTP and OLAP data modeling
Assist in designing and implementing changes to a complex database environment as requested.
Database consolidation strategies
SQL Server remote management
Windows
Windows Server administration or Software installation
Active Directory
Windows 2016 or later certification
Uses remote management tools such as, NetOp and Microsoft Remote Desktop.
Utilize Microsoft Office tools to document processes and procedures.
Experience with Graphical User Interface (GUI) database management tools, to include:
Microsoft SQL SQL Server Management Studio and SQL Profiler
SQL Server Failover Clustering
MySQL Workbench (including Database Design & Modeling, SQL Development, Database Administration)
Additional Requirements (not required on matrix)
Valid U.S. Driver's License is required.
✨ Smart • Intelligent • Private • Secure
Practice for Any Interview Q&A (AI Enabled)
Predict interview Q&A (AI Supported)
Mock interview trainer (AI Supported)
Ace behavioral interviews (AI Powered)
Record interview questions (Confidential)
Master your interviews
Track your answers (Confidential)
Schedule your applications (Confidential)
Create perfect cover letters (AI Supported)
Analyze your resume (NLP Supported)
ATS compatibility check (AI Supported)
Optimize your applications (AI Supported)
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
O*NET Supported
European Union Recommended
Institution Recommended
Institution Recommended
Researcher Recommended
IT Savvy Recommended
Trades Recommended
O*NET Supported
Artist Recommended
Researchers Recommended
Create your account
Access your account
Create your professional profile
Preview your profile
Your saved opportunities
Reviews you've given
Companies you follow
Discover employers
O*NET Supported
Common questions answered
Help for job seekers
How matching works
Customized job suggestions
Fast application process
Manage alert settings
Understanding alerts
How we match resumes
Professional branding guide
Increase your visibility
Get verified status
Learn about our AI
How ATS ranks you
AI-powered matching
Join thousands of professionals who've advanced their careers with our platform
Unlock Your Database Administrator Potential: Insight & Career Growth Guide
Real-time Database Administrator Jobs Trends in Vancouver, Washington, United States (Graphical Representation)
Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Database Administrator in Vancouver, Washington, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 14668 jobs in United States and 251 jobs in Vancouver, Washington. This comprehensive analysis highlights market share and opportunities for professionals in Database Administrator roles. These dynamic trends provide a better understanding of the job market landscape in these regions.
Great news! First Tek, Inc. is currently hiring and seeking a Database Administrator 2 to join their team. Feel free to download the job details.
Wait no longer! Are you also interested in exploring similar jobs? Search now: Database Administrator 2 Jobs Vancouver Washington.
An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at First Tek, Inc. adheres to the cultural norms as outlined by Expertini.
The fundamental ethical values are:The average salary range for a Database Administrator 2 Jobs United States varies, but the pay scale is rated "Standard" in Vancouver Washington. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.
Key qualifications for Database Administrator 2 typically include Other General and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.
To improve your chances of getting hired for Database Administrator 2, consider enhancing your skills. Check your CV/Résumé Score with our free Resume Scoring Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.
Here are some tips to help you prepare for and ace your job interview:
Before the Interview:To prepare for your Database Administrator 2 interview at First Tek, Inc., research the company, understand the job requirements, and practice common interview questions.
Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the First Tek, Inc.'s products or services and be prepared to discuss how you can contribute to their success.
By following these tips, you can increase your chances of making a positive impression and landing the job!
Setting up job alerts for Database Administrator 2 is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!