SQL DBA Resume Sample
Work Experience
- Participate in an on-call support rotation and provide non-standard work hour support
- Provides database support to business users. Restores functionality to database processes that have failed, documents resolutions, and creates and maintains troubleshooting documentation
- Employs general SQL, Microsoft T-SQL, and Oracle PL/SQL languages, stored procedures, Date Transformation Services (DTS) scripts, and SQL Server Integration Services (SSIS) to manage database systems and to automate data migration and processing
- Designs, develops and implements database tables, views, triggers, indexes, and stored procedures to ensure data integrity for custom applications. Communicates with IT management, and peers regarding database solutions and potential enhancements
- Designs, develops, tests, documents, and implements scripts to automate data importing, exporting, reporting, and analysis to ensure data confidentiality, availability and integrity
- Experience with supporting and troubleshooting SSIS packages
- Experience in writing stored procedures and views
- Develops database architecture and standards
- Configures and upgrades database software
- Solid skills in database performance fine tuning and optimizing poorly performing queries, stored procedures
- Production patch/upgrade management
- Acts as a an escalation point for more junior SQL DBA team members for advanced skills and troubleshooting
- Build and maintain strong working relationships with other DBAs and application teams
- Strong skills in configuring and administering SQL Server Replication and DR solutions
- Participate in a fixed shift pattern/on-call rotation/weekends
- To exhibit an objective, fair and professional attitude that exemplifies the principles outlined in The Decoma Employee’s Charter to maintain a positive and productive workplace
- To meet and maintain all customer quality standards as well as the standards of Decostar
- Maintains the overall enterprise database architecture including number of instances and how each is used
- Designs and implements databases in conjunction with the application development and Enterprise Data Analyst teams
- Provides consultation and trouble shooting for the development team
- Implements and maintains database security
- Provides 7X24 database support for production databases
- Design build, configure, upgrade, and manages database installations
- Proactively monitor and perform database performance tuning activities
- Provide input into overall development/implementation plan and document database builds and changes, perform SQL designs, table designs, and stored procedures work
- Translate logical to physical design, develops comprehensive DB architecture, implementation and upgrade plans and assists in definition of database standards, policies, and procedures
Education
Professional Skills
- Strong SQL writing skills - 3+ years of experience
- Strong production support experience and customer service skills
- Demonstrate excellent analytical skills and attention to detail
- Strong working knowledge of SQL Server administration skills including backups, scripting, administration, database maintenance, and application maintenance
- Demonstrates creative critical thinking capabilities and troubleshooting skills
- Strong organizational, communication and problem-solving skills
- Strong performance tuning skills in a very large database environment
How to write SQL DBA Resume
SQL DBA role is responsible for sql, database, server, documentation, business, programming, research, security, training, automation.
To write great resume for sql dba job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For SQL DBA Resume
The section contact information is important in your sql 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 SQL DBA Resume
The section work experience is an essential part of your sql 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 sql 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 sql dba position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative SQL DBA resume experience can include:
- Strong verbal and written communication skills with the ability to interact professionally with all levels in the organization
- Strong knowledge of how indexes and statistics affect database performance and storage requirements. Including how to create and manage them effectively
- Excellent interpersonal communication skills and the ability to work with individuals from the business as well as the IT department
- Good communication, presentation and documentation skills
- Scripting skills: Perl, Python, and Bash
- Experience and/or understanding of HTML, CSS, JQuery, JavaScript, report scheduling tools, and data security models - 2+ years of experience
Education on a SQL DBA Resume
Make sure to make education a priority on your sql dba resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your sql 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 SQL DBA Resume
When listing skills on your sql 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 sql dba skills:
- Strong coding skills in T-SQL, SSIS, SSRS
- Strong analysis skills in Oracle and SQL server databases in live production environments providing business critical business services
- Demonstrated writing skills and attention to detail
- Experience and Administration skills in SQL Server 2005/2008/2012
- Excellent interpersonal skills with the ability to work independently and collaboratively
- Comprehensive database skills, spreadsheet experience, and analytical expertise are required
List of Typical Experience For a SQL DBA Resume
Experience For Senior SQL DBA Resume
- Strong Experience with Data Modeling, Warehousing, Relational Database
- Strong experience in Database Administration in SQL Server (2008 through 2014)
- Professional experience in hands-on experience in Oracle & SQL Server database
- Multi-task and context switch effectively between different projects and team members
- Significant experience as a Data Base Administrator with at least 2 years previous experience in a similar role
- Logical thinker with sound decision making and problem-solving skills
Experience For SQL DBA / Developer Resume
- Good experience in peer teams and vendor coordination required to deliver end results
- Experience SQL Server Administration experience in a production environment
- Demonstrated multi-database synchronization experience and SSIS development
- Strong experience with SQL Server versions 2008R2 to 2016 database
- Strong experience T-SQL language and Powershell
- Strong experience with high-availability databases required
- Strong experience with database tools and utilities
Experience For Oracle / SQL DBA Resume
- SSIS package skills are nice-to-have
- Experience developing, deploying, and refining system architectures
- Extensive experience writing and performance tuning of SQL queries
- Experience with database design best practices, including normalization, query optimization, referential integrity and logical database architecture
- Experience developing efficient stored procedures, views and triggers
- Experience with the latest Microsoft SQL Server and Windows Server operating systems
Experience For Senior MS SQL DBA Resume
- Experience with IBMi, and data replication using SSIS, IBM Data Replication or DataStage, helpful
- Lock escalation + performance tuning experience required
- Experience administering SQL Server
- Experience with transnational, EAV and Dimensional modeling types
- Experience in supporting multi-instance SQL Server 2008 R2 – 2016 environments
- Practical knowledge and experience with performance tuning
- Experience supporting SQL, MySQL in Windows environment
Experience For SQL DBA Administrator Resume
- Experience supporting MySQL, PostgreSQL in Linux environment
- Experience with other relational databases, BI reporting and data discovery tools is highly desirable
- Five years MS SQL Clustering experience
- Identifies tasks and processes requiring automation and implements the most effective solution
- Experience in designing MySQL/MSSQL, POSTGres, Mongo database platforms would be beneficial
- Someone with a good understanding of SQL security and also Active Directory security and how that impacts security on SQL server
- Experience working with SSIS packages
Experience For Oracle & SQL DBA Resume
- Experience trouble-shooting query performance
- Proven track record in supporting multiple DB simultaneously
- Thorough understanding and demonstrated practical application of tools, methodologies and design concepts in the area of database management
- Recent experience in MS SQL Server versions 2008/2012/2014
- Experience with SQL Server High Availability (HA) and Disaster Recovery (DR)
- Database and Instance creation, validation, upgrades/migrations and maintenance/support
Experience For SQL DBA / Developer, Sunderland Resume
- Advanced knowledge/experience in SQL Server Database Administration, Development and ETL processes (SSIS)
- Experience with SQL Server virtualization
- Strong knowledge of backups, restores, database mirroring, replication, Change Data Capture
- ITIL foundation qualified or equivalent ITIL experience
- Hands on experience in SQL Database Administration L2/ L3/L4
Experience For Senior DBA 1-SQL DBA Resume
- Experience in Database and ability to manage a team
- Manages multiple commitments and prioritizes based on management feedback
- Experience with Power BI and other Business Intelligence tools, helpful
- Experience with Powershell, helpful
- Experience in Information Technology
- Experience as a senior-level DBA
- MS SQL Server Administration experience required
Experience For Junior SQL Dba Resume
- Experience with Peer to Peer and transactional replications
- Prioritize workload and produce highly confident estimates for all solution implementations
- Hands-on experience with MS Failover Clusters and Availability Groups
- Experience with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services SSRS
- Demonstrated successful implementation / knowledge of the following technologies
- DBA experience in large environment
Experience For Oracle / SQL DBA / Senior Systems Specialist Resume
- Experience in producing detailed system and procedural documentation
- Commercial experience with SQL Server 2008 and above (SQL Server 2016 highly desirable)
- Effective communication (both written and verbal)
- Experience in the planning and deployment of high-availability database environments (Always-On, Clustering, Mirroring, Replication, Log-shipping)
- Experience in database performance tuning and process optimization
List of Typical Skills For a SQL DBA Resume
Skills For Senior SQL DBA Resume
- Good experience in Customer handling (understanding Customer pulse and delivering the right solution)
- Excellent experience and understanding of patching, cloning, Enterprise Manager Cloud /Grid Control 12c, security, RMAN backup and recovery procedures
- General programming skills using .NET, Java, Powershell, Python, etc
- Commitment to developing professional skills through training programmes and recognised qualifications
- Good knowledge and experience setting up and administering Mongo DB and/or NoSQL Database
Skills For SQL DBA / Developer Resume
- Experience with data modeling, and experience with querying relational databases such as SQL Server
- Very good experience writing SQL Queries and fine tuning queries and databases to improve performance
- Expert Level skills in providing 24x7 DBA Level 4 support in Production, QA and Development
- Documentation skills for processes and procedures ( creating runbooks, topology etc )
- Technical database administration experience or combination of training and experience is required
- Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
- Effectively research, develop, test and implement new Database Tuning and maintenance procedures
- Utilize knowledge of how indexes and statistics affect database performance and storage requirements. Including how to create and manage them effectively
- Knowledge of programming skills such as in T-SQL, PowerShell, VBScript, etc
Skills For Oracle / SQL DBA Resume
- Positive customer service skills and personal initiative complimented by an elevated sense of accountability and urgency
- Demonstrated knowledge of good relational database development practices
- Experience across all versions of MS SQL Server, expert experience with SQL 2012 and 2016
- Identifying, reporting and resolving data migration issues, incompatibility issues, invalid objects, obsoleted functionalities
- Scripting and other coded experience
- Mirroring Experience with SQL Server 2008,SQL 2012, and SQL 2016 RDMS servers
Skills For Senior MS SQL DBA Resume
- Securing and optimization of databases experience
- Experience in performing tuning, query optimization, using performance monitor, SQL profiler and other monitoring and troubleshooting tools
- Experience with Performance Tuning and optimization using native monitoring and troubleshooting tools
- Experience in database performance tuning and optimization, using native or third-party monitoring and troubleshooting tools
- Experience supporting and troubleshooting SQL data replication using GoldenGate
- Experience implementing and maintaining SQL Server high-availability techniques including AlwaysOn Availability Groups
- Skilled in performance tuning, troubleshooting, system monitoring, and administration of SQL Server 2008 through 2016
Skills For SQL DBA Administrator Resume
- Thorough understanding of High Availability and DR including working experience of SQL Server availability group
- Experience working with enterprise level systems using SQL Server
- Have hands-on experience in Cloning and provisioning of MS-SQL environment
- Work experience: SQL clustering and virtual server clustering, data replication and fail-over
- Experience in troubleshooting and resolving complex database problems
- Experience in implementing operational automation using scripts - preferable
- Experience with performance monitoring and tuning (PTO)
Skills For Oracle & SQL DBA Resume
- Experience creating and editing stored procedures
- Experience in administrating/configuring databases in a Windows 2016 clustered environment
- Has knowledge of and experience with more advanced DB concepts like backup and recovery, monitoring, performance tuning
- Extensive experience in creating/managing automated deployments
- Experience with production support, ensuring backups are functioning, add space, query optimization, table creation
Skills For SQL DBA / Developer, Sunderland Resume
- Experience designing / working with SQL High Availability Clusters
- Experience implementing operational automation using scripts
- Experience of replication + clustering (Always-On) + mirroring
- Experience of database: analysis + troubleshooting + tuning databases
- Extensive experience setting up and administering MS SQL Server databases
- Exposure to developing reports using multiple Business Intelligence applications - 3+ years of experience
Skills For Senior DBA 1-SQL DBA Resume
- Min. 3 years of experience in - Microsoft SQL Server-Advance Database Administration, Database Clustering, Replication, Log Shipping,
- Experience working with high volume, high availability database systems
- Experience with SQL Azure, COSMOS big data platform and SCOPE scripting
- C# Programming & Experience with .NET Framework and Visual Studio IDE, DAL and ORM development
- Experience creating data warehouses
- Experience managing SQL as a service in Azure (or AWS)
- Experience in implementing recovery procedures and disaster recovery function to protect the MS SQL database
- Experience creating ETL packages (SSIS)
- Experience working as an active member of a database administration team, production DBA
Skills For Junior SQL Dba Resume
- Experience in developing in Informatica BDM, SSIS or similar ETL development tools
- Highly competitive benefits package including excellent pension and private medical cover
- Proven ability to organize and plan work independently in a rapidly changing environment
- Possess a solid understanding of the relationships of architecture components within the company’s technology infrastructure
- Hands-On experience with Backup, Recovery and day to day troubleshooting for MS-SQL server and database
- Excellent communication and customer handling
- Experience in Database Administration using MS SQL Server 2012/2008 R2 /2005
Skills For Oracle / SQL DBA / Senior Systems Specialist Resume
- Strong working knowledge of SQL Server 2000, 2005, and 2008
- Related systems engineering experience
- Experience in Perl/Shell scripting - preferable
- Experience with database partitioning, database compression, data encryption, replication, and disaster recovery
- Experience in Database Replication, Database Mirroring
- Experience working in a high transaction, 24x7 Microsoft SQL database environment
- Experience working in Agile development and operations environment
- Demonstrated proficiency of tuning and administration of large Microsoft SQL databases
List of Typical Responsibilities For a SQL DBA Resume
Responsibilities For Senior SQL DBA Resume
- Hands on experience with DB high availability especially in the area of Replication and Database mirroring
- Hands-on experience with SQL server monitoring tool such as Foglight and Orion
- Experience with EAV and Dimensional modeling types
- Create custom SQL to query complex data models in the most effective way for the database and the application servers
- Experience with Oracle Golden Gate and/or Streams or any other real time replication technology
- Experience with Operational DBA Administration
Responsibilities For SQL DBA / Developer Resume
- Strong background in support of highly distributed environment of databases, Business Intelligence Services and Data Warehouses
- SQL Database Administration experience
- Proven ability to develop and implement data design models on enterprise level applications
- Extensive experience with database transactional replication
- Experience supporting SQL Server 2005/2008/2012 replication
Responsibilities For Oracle / SQL DBA Resume
- Conducts and validates database backups
- Ecommerce support experience
- Work experience is required
- Experience in database management in SQL Server 2005, 2008R2-2012 and 2016 environment
- Experience with SQL Server 2005 to 2016
Responsibilities For Senior MS SQL DBA Resume
- Experience in SQL Server database administration
- Experience with database encryption and backup/recovery methodologies
- Experience with AWS or Azure is a nice to have
- MS SQL Server Administration experience required
- SQL DBA (Recent experience in SQL Server 2000 and 2014)
- SQL Database administration experience
- Working with the development team. Main focus is improving the performance of the application and optimization of the applications
Responsibilities For SQL DBA Administrator Resume
- Experiencing with Windows servers, Windows Scripting and Active Directory Services
- Monitoring: Splunk, Application Performance Monitoring, Quest Spotlight
- Monitoring and tuning all SQL databases to ensure high availability
- Troubleshooting performance issues and fine-tuning queries and stored procedures
- Writing and Tuning SQL, T-SQL, and database stored objects (packages,triggers,etc)
- Working knowledge of file groups and partitioning of tables
- Upgrading and upsizing databases from earlier versions to the latest versions
- Applying and testing maintenance fixes
- Maintaining high-availability systems (7x24x365) in production environment
Responsibilities For Oracle & SQL DBA Resume
- Monitoring Applications within a non-production environment
- Writing stored procedures (how to manage and write them more efficiently)
- Monitoring of system health and performance, to ensure high levels of performance, availability, and security
- Making sure back-ups are complete
- Working with the Technical Architect and Enterprise Infrastructure Manager, to act as a technical design authority for the organisations MS SQL Platform
- Understanding of backup and recovery processes with SQL Server
Responsibilities For SQL DBA / Developer, Sunderland Resume
- Understanding of key business processes
- Providing technical support to the application developers
- Reviewing new databases that come with purchased packages
- Translating business requirements into technical requirements and designs
- Supporting the Production IT team when application-related issues arise
- Meeting time critical deadlines
- Ensuring 100% accuracy in data files
- Advanced knowledge of SQL Server Performance Tuning including Partitioning, Clustering and Indexing
Responsibilities For Senior DBA 1-SQL DBA Resume
- Maintain SQL Server high availability options including clustering, log shipping and mirroring
- To perform performance tuning and optimisation using native monitoring and troubleshooting tools
- Develop and maintain a variety of reporting systems both internal and client facing using SQL Server reporting services
- Background in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- Data Replication to support data warehousing and reporting
Responsibilities For Junior SQL Dba Resume
- Familiarity with SQL Server tools including Profiler and Tuning Advisor
- Input and consulting to software development and implementations utilizing NonStop/SQL
- Assist with Data Modeling, Data Mining, SQL and COSMOS/SCOPE Development
- Assist system DBA team by deploying SQL Server upgrades and service packs and performing backup, recovery and archival tasks on databases management systems
- Perform data and reporting queries using the data warehouse
- SQL Query authoring and troubleshooting, proactively optimize system performance. Support both OLTP and OLAP systems
Responsibilities For Oracle / SQL DBA / Senior Systems Specialist Resume
- Proficiency in Transact-SQL (TSQL) and stored procedures. Upgrading, and patching SQL Servers to most current versions
- Participate in physical database design by reviewing or generating DDL as needed
- Performance tuning: physical server, database & query tuning
- Responsible for configuring High Availability and Disaster Recovery (DR) while working closely with the Business Continuity Team
- Provide support and maintenance for daily administrative tasks including transports, OSS notes, performance monitoring, root cause analysis, etc
- Conduct ongoing monitoring and maintenance to ensure stability and optimal performance on all assigned server environments
- Knowledge of Windows Operating System (OS) and clustering component