Junior DBA Resume Sample
Work Experience
- This is a virtual/remote position which can be performed from most states within the United States
- Under general supervision supporting and engineering of the Key Bank SQL Server/Sybase/LUW platform(S) along with the associated infrastructure
- Understanding and experience with the installation and configuration of SQL Server, Sybase & LUW software - according to Key standards
- Test and coordinate modifications
- Audit, modify, and amend data in systems using SQL commands, hand-editing, and bulk import
- Ensure system is running smoothly and troubleshoot and correct issues as they arise
- Add new users to the system as needed
- Enhance or build database designs
- Scan all database instances and recommend security mitigations of vulnerabilities to the DBA team
- Provide risk assessment reports to management for accreditation of systems
- Document and implement security procedures
- Work within a close team construct and coordinate with various teams in a timely manner and in accordance with defined standards and practices
- Experience in Information Technology, ideally within database administration
- Installation and maintenance of Data Base Software and patches
- Configuration and testing of initial installations
- Upgrade CE hosted databases
- Manage Database user administration, including role and privilege management
- Providing database security administration such as User ID’s, Passwords, roles, etc
- Manage and maintain logical database structures, physical structures, data, file systems, disk sub-systems, accounts/passwords, logical and physical backups, and database tuning
- Perform DBA tasks to install, configure, test, maintain, backup, recover, patch, and upgrade
- Perform database analysis, design, and implementation
- Interface with Tech Support for information gathering, trouble-shooting, and general technical support for security patches, installs, upgrades, etc
- Tune, administer, and maintain SQL Server instance according to set standards
- Develop and document procedures for backup and recovery of SQL Server database environments
- Patch, upgrade, and maintain all SQL Server binaries
Education
Professional Skills
- Serving as a DBA in all facets of DBMS design, implementation, deployment, administration and maintenance, and project coordination and support of production and development environments
- Planning & Organising; Ability to set priorities, goals and time tables to achieve maximum productivity
- Communicating with Impact; Ability to effectively exchange information, news, ideas and meaning in a business environment
- Resolves load, processing, reporting (extract), and other data management issues.; Validates, loads, tests, and verifies data
- Candidates with additional experience supporting SybaseASE and/or SybaseIQ would be given extra consideration
- Experience with other database Oracle, MySQL, open source postgress
- Experience with replication (merge and transactional)
How to write Junior DBA Resume
Junior DBA role is responsible for design, reporting, architecture, security, auditing, database, integration, software, administration, planning.
To write great resume for junior dba job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Junior DBA Resume
The section contact information is important in your junior dba resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Junior DBA Resume
The section work experience is an essential part of your junior dba resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous junior dba responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular junior dba position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Junior DBA resume experience can include:
- Auditing database activities
- Conduct Performance Monitoring and Tuning
- ETL processes using T-SQL bulk insert, DTS, & SSIS to create new imports or optimize and correct bugs in existing imports
- Development and maintenance of reports using Microsoft Reporting Services (doesn't need to be a master)
- Familiar with Windows, Linux, and AIX operating systems, tools and architecture as they relate to supporting database environments
- Performs complete functional testing of database structures and verifies information provided in all environments including development, test, and production
Education on a Junior DBA Resume
Make sure to make education a priority on your junior dba resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your junior dba experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Junior DBA Resume
When listing skills on your junior dba resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical junior dba skills:
- Independently and effectively learned the intricacies of in house applications and ETL jobs
- Knowing that there is no SSMS or SSIS for SQL2000 is important, as is how to avoid issues opening packages and how to save them to disk
- During meetings, knows that it is inappropriate, to text/chat/Facebook
- Performing installations, upgrades, migrations, and patching
- Monitoring and tuning database performance
- Responding to client tickets and email requests
List of Typical Skills For a Junior DBA Resume
Skills For Junior DBA Administrator Resume
- Knowledge of and experience in database environment life cycle management and support of production and development environments
- Has an understanding of data architectures, database management system facilities and capabilities, and the operation and tuning of databases
- Design and implement databases using industry standard methodologies and present to stakeholders
- Awareness of Tuning on both Oracle and SQL Server databases
- Develops source file processing logic, retention, and archive recommendations and develops documentation to support the database environment
- Optimizes/balances processing and performance for peak and load
- Identify and initiate quality improvement measures
- Accountable for the operational support of the Database estate, processes for Development and Test environments (System, Load, Performance, UAT) up to, and including Production
- Process, best practice and database build standards are consistently applied and constantly improved upon
Skills For IT Dba, Junior Resume
- Database health checks, backups and implementation of DBA best practise
- Knowledge of SQL Server 2005, 2008, 2008 R2, 2012, 2014
- Awareness of the Oracle and SQL Server toolsets
- Knowledge SQL & PL/SQL and T-SQL knowledge
- Drive & Energy; Self–motivated and driven to succeed, focused on results and passionate about the job
Skills For Junior Data Analyst / DBA Resume
- Creativity & Innovation; Ability to generate and translate an idea into a product or service that creates value for business
- Maintains database and ensures its availability to users
- Transfers and replicates data accurately and quickly
- Prepares appropriate dimensional data structures and provides logical interfaces for the extract/transform/load (ETL) process
- Implements designs and structures provided by Systems and Data Architects
- Monitors database performance and assists with database security.; Maintains the data dictionary and database backup and recovery
- Assists, defines, and/or oversees database organization, standards, controls, procedures, and documentation
Skills For Junior Operational Dba-this Position may be Filled Remotely Resume
- Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. This includes maintenance of database dictionaries and integration of systems through database design
- Configure and monitor Database backups including both hot and cold backups
- Identify other SSIS packages that are using the current database, and create projects to update them
- Outline, replicating current cubes into Azure, for Power BI Implementation
- Development, Performance Tuning, Optimization and maintenance of stored procedures, triggers, and user defined functions
Skills For Junior DBA Resume
- Propose technical solutions to business problems on a proactive basis, needs to understand when to bring these things up
- Maintains and documents shell scripts and batch processes
- Oracle Database exports and imports as required
- Monitor and manage alert logs and trace files
- Normal and emergency database startup and shutdown processes
Skills For Junior DBA Administrator Resume
- Troubleshooting service outages as they occur. Track and resolve database related incidents and alerts within client service levels by following incident management procedures
- Downgrade MS SQL dev servers from enterprise licenses, while retaining all their settings
- Convert old DTS packages to SSIS, done in multiple steps
- Create new destination, DB with associated SP’s and views
- Recreate the DTS packages
- Learn and develop Prototype, in MS PowerApps for BBO or DPR
- Crosstrain, Magic Software, DSI application platform, BOE, Insight, and JDE
Skills For IT Dba, Junior Resume
- Installation/nuts and bolts of MS SQL Server, 2000-2016. Example knowing how to move temp DBs, and what is the importance of SQL version when attaching a database from another server
- Convert DTS Packages to SSIS packages and T-SQL stored procedures used as bulk insert from hospital systems to the local database
- Switch between TSQL, DB2 SQL, Oracle SQL
- Most important things technically are understanding/installing/moving things in SQL Server. Converting DTS to SSIS. Knowing how to demote from enterprise to dev. Things like moving databases on disk from one spot to another and how to detach, etc
- Database Report Creation