Prepared documentation for end user training. Versions include 2005, 2008, 2008R2, 2012, will all sub-levels and fix packs, 5+ years Experience supporting MS SQL Server on clustered server systems, including HADR, 10+ years Experience supporting MS SQL Server on clustered server systems, including HADR, At least 2-3 year experience/or solid knowledge in the Microsoft operation field, At least 2-3 year experience/or extensive knowledge of Microsoft SQL server products, including MSSQL 2005, 2008 and 2012 (2014) Server AND/OR, Strong knowledge and skills of T-SQL scripting, Experience with Reporting Services and Analysis Services of MSSQL Server, Deep knowledge of Microsoft Operating Systems (incl. ), Server side Storage products and concepts (SAN, etc..), Business Intelligence Services (SSIS, Analysis Services, Reporting Services), Extensive work experience on AWS Operation & Architecture, Hands on experience on deploying, configuring databases like (Aurora, MySQL, SQL Server) on AWS Environment, Manage databases ensuring accuracy and completeness; provide conceptual design, capacity planning and data loading and maintenance; planning included database definition, structure, documentation, long-range requirements, operational guidelines and protection, Assess business requirements and data storage and retrieval system capabilities, Experience in Couchbase database installation, configuration and performance handling, HA/DR, Must have knowledge on “No SQL” databases and Architecture and should have prior experience implementing NoSql databases, 3-6 years of Information Technology experience in an IBM environment in a global environment, Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives(RPO), Test backups to ensure that we can meet the business’s Recovery Time Objectives(RTO), Troubleshoot SQL Server outages as they occur and resolve SQL Server incidents from the ticket system, Install and configure SQL Server, including standalone and clustered instances, Deploy database change scripts provided by the support team, Upgrade and patch SQL Server services under high availability infrastructure with “Fail-Over Clustered Instance”, “Always-On Availability Group” and “Log-Shipping”, Increase operational efficiency by leveraging automation solution such as PowerShell scripting to refresh multi-tenant database instance, Troubleshoot and deploy SQL Server business intelligence solutions for reporting service and integration service, Implementing high availability solutions like AlwasyOn, Mirroring, Replication or Log Shipping, Knowledge of MS SQL Server 2005, 2008, 2008R2, 2012, 2014, Knowledge of Windows 2003, Windows 2008, Windows 2008R2 and Windows 2012, Responsible for all General Database Administration functions associated MS SQL Server systems including security, back-up, logging, reporting and recovery procedures, Management of all technical aspects of the databases, processes, and systems, Assist in improving and maintaining database operational efficiency, Perform daily, weekly, and monthly data maintenance tasks, Operational monitoring of SQL Infrastructure, Assist in client support and setup configurations, Assist clients in developing and implementing data systems management processes, Test various internal applications and commercial apps, Transform data via standardization, cleaning, data repair, matching, and de-duping, Provide Client Thought Leadership in the database systems space, Mentor and support peer and new consultants, Experience with MS SQL Server 2005, 2008, 2008 R2, 2012, and 2014including use of all native management, configuration, and performance tools, Experience with designing, testing, deploying, and stabilizing MS SQL Server infrastructure systems, Ability to rapidly assess MS SQL infrastructure status relative to client goals, Experience with MS SQL Server Failover Clustering and MS Windows Server Failover Clustering, 5+ years consulting experience or demonstrated ability, Familiarity with managing data in Microsoft Access and Excel, Experience in Data Warehousing/Business Intelligence, Proficiency in database tuning and query optimization, Proficiency with SQL Server Integration Services, SQL Server Reporting Services, SQL Profiler, and SQL Server Management Studio, Experience using tools like RedGate's SQL Monitor to diagnose server reliability and performance issues, Develops, documents, implements and maintains standard procedures for all DBA tasks, Provides backup for Sr. Conduct high level design session with the development team? Click on the Download button relevant to your (Fresher, Experienced). Designed and developed Packages, Stored procedures, Functions and Triggers, Views and complex SQL statements for applications. Monitor database "health" - availability, reliability, performance, capacity planning, server clustering. Manage escalations and sub-cases to ensure timely and high quality resolution of all issues, Partner with Premier Service Delivery Managers to effectively manage hot-sites including documented action plans and daily status updates for the customer and Microsoft management, Develop working relationships within the PFE Organization that result in increased cooperation and mutual support in fulfilling our customer mission, Develop a working relationship with Microsoft Consulting Services (MCS), CTS and field staff at your accounts that results in increased cooperation and mutual support in achieving each other's goals, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005, Exposure to and some knowledge about SQL Server 2014, Fair knowledge on Windows clustering - Windows 2008 R2, Windows 2012 and Windows 2012 R2, Deep technical knowledge/experience on SQL HA/DR solutions, Practical experience troubleshooting performance problems, query tuning and optimization, Experience delivering and/or authoring technical training, University degree, preferably in Computer Science. Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing. Participated in the creation of the replacement system that would facilitate the accurate and timely payments to banks from the FDIC for bad mortgage debt. Create and analyze complex queries. Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams. Migrated data from in-house built much smaller database (about 50 tables) to much larger open source database (Ofbiz with about 500 tables), Designed and re-developed all the existing reports and SSIS packages based on new data model as part of Data Migration project, Interact with the business users; analyze the issue or enhancement request, design the solution, full testing and implementation. Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions. desired, Experience developing SSIS packages (data flow tasks, transformations, precedence constraints, expressions, etc.) Data architecture, design and creation of MS SQL tables, views, triggers and other objects required for web statistics & analysis. Professional Summary. If you have the space to include it, you should. 5+ years total experience (3+ years of which with SQL relational database development and support including SSIS package development and support) 2+ years SSRS development and support. Proficient in Relational Database Management Systems (RDBMS). Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS. 10%, Perform database performance analysis, tuning and disaster recovery 30%, Configure database backup and perform backup/recovery testing. Microsoft SQL Server DBA Resume Examples & Samples. Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts. Will consider related equivalent experience, Ability to manage challenging technical issues by setting customer expectations, devising and implementing action plans, participating in on-call shifts, having a willingness to go the extra mile and professionally communicating to all parties involved, Excellent knowledge of MS SQL 2008 R2, 2012 and 2014 Enterprise, Excellent knowledge of Windows Clustering and SQL Clustering, Proficiency in installation, configuration and administration of MS SQL database software including understanding of Analytic Cubes, Must be knowledgeable about underlying MS SQL database architecture schemas/products, database objects, file system structure, tables, views, packages, procedures, functions, triggers, sequences, indexes, and constraints, Knowledge of power shell scripting and ability to write his/her own scripts to support maintenance or auditing, Expert in Database structure changes, table/index sizing, Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations required and advanced troubleshooting techniques such as block dumps, setting event traces etc, Expert in database backup/recovery, Database High Availability configurations, Fail-over, Disaster Recovery concepts, Should have good understanding of the underlying network and storage concepts such as SAN, NAS, Amazon EBS, etc, Be able to provide on call support and after-hours support for system maintenance, Prior experience supporting Federal agencies is a plus, Prior experience support and administering Crystal Reports is a plus, Prior experience with Amazon AWS or GovCloud is a plus, Must have good communication & documentation skills, At least 7+ years of hands-on experience supporting high transaction volume databases in a mission critical environment such as ERP systems, e-commerce, Bachelor degree in engineering related studies highly preferred, Help upgrade SCCM SQL Instance to SQL 2012 R2, Design and Implement SCCM Software Center, Help develop process for managing and maintaining Gold Images, Assist with improving the work and function of SCM Imaging, Experience with CAS (Central Administration Server), Experience with Microsoft SCCM and related technologies, Microsoft Sequel Server 2008 and Up experience (2012 R12 Experience important), Must possess experience with Sequel Migration, SCCM Upgrade and Deployment 15.11 or 16.02 is a must, Desktop Imaging Expertise Windows 10 experience, Bachelor's Degree in Information Systems, Information Technology, Computer Science or Engineering or a 2 year degree with a minimum of 4 years of experience in the application of information technologies to business solutions, Minimum of 5 additional years of experience with SQL Server as a professional DBA in a large business environment, Possess unrestricted authorization to work in the United States, Administrative experience with one or more other database technologies including Oracle, PostgreSQL, Solaris or Linux experience with basic system administration skills, AWS / RDS experience supporting databases in the cloud, Experience with other SQL Server components – SSAS, SSRS, SSIS and key features of SQL Server, including replication and Always On, Experience with database automation leveraging Ruby, Python, Chef or other programming tools, Proficiency in PowerShell scripting specific to database administration and automation, Provides leadership to identify practical solutions to improve performance and availability for support applications and infrastructure, Ability to influence and build consensus with other IT teams and leadership, Experience integrating SQL Server with SharePoint, Experience tuning SQL Server infrastructure to provide optimal performance, Experience identifying and capturing metrics on SQL Server performance, Experience providing Tier 4 support for operational enterprise, Experience with SQL Server integration with antivirus/malware applications, Experience identifying requirements for new SQL Server projects, Experience creating needed design documentation, Experience evaluating and providing input to Microsoft Project schedules, Experience with customer field environment, Act as technology lead for Microsoft SQL Server Failover Cluster, Act in a supporting role in the administration of Oracle databases, Produce and review detailed technical documentation, Review and remediate security vulnerabilities, Provide 24/7 support coverage as part of a rotation, 5-7 years progressive experience in database administration in an enterprise environment, Expert in-depth knowledge of SQL Server 2008R2, 2014, Strong Windows Server 2008-2012 System Administration and Powershell skills, Strong knowledge of SAN concepts including various RAID solutions, Team player with excellent organization and interpersonal skills, Ability to manage workload autonomously and establish the right priorities related with business needs, A Government of Canada Secret Level (Level II) security clearance is required, Knowledge of Oracle RAC , Dataguard , RMAN, Knowledge of Microsoft SQL Server Reporting, Analysis and Integration Services (SSRS, SSAS and SSIS), Understand and apply advanced database administration, management and performance tuning techniques specific to SQL Server, Proactively identify trends in SQL statements and provide recommendation for efficient use of resources, Proactively identify resource requirements to ensure high availability of database systems, Provide technical advice and expertise to less senior staff members, Develop advanced shell scripts, SQL scripts in support of database operations, Enforce Security policies and procedures on databases, Write and maintain documentation describing changes and modifications to all systems and databases, Perform exports, backups, restores, refreshes and data extracts as required, Act as technical liaison in support for database related project activities, Develop strong working knowledge of key applications and their interaction with the database(s), 4-5 years in Windows 2000, 2003 and 2008 server environment, 5-8 years as a database administrator working with SQL 2005, 2008, 2012 and 2014 environments, Experience with SQL Always On and Active/Active Peer to Peer Transactional Replication, Experience with telephony billing systems and related applications a big plus, High degree of skill with database commands and monitoring utilities such as SQL Profiler, Spotlight, FOGLIGHT, SolarWinds, Red-Gate etc, Advanced knowledge of database administration tasks such as backups, database recovery, security, etc, Advanced knowledge of debugging and performance tuning stored procedures, UDFs and triggers, Advanced installation and configuration experience, Advanced knowledge of hardware, including clusters, RAID, multi-processor architecture, etc, Advanced knowledge of VBScript and advanced DTS, SSIS package design, Strong knowledge of high availability and disaster recovery architecture, Solid experience with the Windows operating system and command set as well as competence with PowerShell scripting, Thorough knowledge of physical and logical disk systems and their impact on database performance, Experience with server and database clustering techniques and the performance impacts, Knowledge of Big Data concepts including NoSQL like Mongo, Instrument & Pricing; servicing product static, intra-day & end-of-day pricing data sets across the Investment Bank’s trading, risk and, middle and back office functions, Client & Counterparty; for managing Counterparty, Client and Account Reference Data within Barclays, Bachelors Degree in Computer Science or related field, Must have extensive experience as Production support SQL Server Database Administrator - experience in large, high volume and high criticality environments, Knowledge of Autosys is highly advantageous, Ability to understand context and respond to users is more important over the in-depth technology skills, Positive, reliable & enthusiastic team player, Experience in work management: planning/prioritizing activities and streams of work, Hands-on experience in SQL Server 2014, 2012,2008 and 2005, Co-ordinates with customers / other teams / vendors in resolving requests and incidents, Installation and configuration of SQL Server DBs, Implementing changes to the database objects, Providing assistance to the application team in identifying database problems, Executing backup and recovery of the database as and when required, Exposure to TDP / TSM for data recovery . Spotlight and Systems Center Operations Manager (SCOM) is a plus, Capable to develop T-SQL stored procedures, functions and Powershell scripts to automate processes and improve system performance, Knowledge of data mapping with logical and physical data modeling, Working experience with physical and virtual servers, Experience with Windows Server 2008 and Windows Server 2012 is mandatory, Experience with SQL Server 2014 is a strong plus. Investigate new approaches and tools for addressing technical needs. Automate processes and create stored procedures that significantly decreased monthly and quarterly reports run time. AD DBA and assist in administering 15+ Windows servers with SQL Server and client application programs, ensuring effective system resource utilization, responsiveness, availability and network connectivity. Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs. SQL Server Business Intelligence Developer Resume Examples & Samples. Strategic, effective use of technology, coupled with high-quality deployment and excellent production support, are essential to ensuring our technology platforms are optimized and can support business activity and the bottom line, Experience with setup/configuration/support of SQL Server 2008,2008R2,SQL2012, SQL2014, Expert knowledge of T-SQL, Powershell scripting. Transform extracted data by loading data into the star schema. Create and maintain database security levels. Instead, what you see below is my pre-consultant resume. Monitored daily Processes for different Data Loads and resolved Issues. Sql Server Developer Resume Examples SQL Server Developers are employed by tech companies and are responsible for creating and maintaining computer databases. 2+ years of experience with designing enterprise scale SQL Server deployments. Responsible for disaster recovery planning for SQL Servers. Resuming a suspended database puts … Worked with business analysts and data analysts to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI and applications. Provide production support for the existing applications and clients; own the support process, documentation and implementation. Provide advice to developer if required, Design, develop, maintain backend software for capture, storage and retrieval of test data that would be used in Capacity and Performance test runs, Design, develop, maintain Capacity and Performance data from tests in form of dashboards to provide data on historical trending on releases, Use output from Dynatrace (application monitoring tool) to proactively tune expensive stored procedures, Capture database schema in Enterprise Architect, Develop and implement database archiving in production environment, Experience of performance tuning in a large-scale database environment in SQL Server 2008 or above with a minimum of 8 years experience, A strong understanding of SQL Server internals and how the query optimizer works, Familiar with dynamic management views and functions and how to diagnose its output, Experience of SQL Server 2008/2012 development or have been a development DBA in this area, Familiar with the new features of 2008/2012/2014 and be able to suggest ways we can use these features to benefit the current application, Production support experience. , Server clustering input to project lead by creating and modifying views, Rules and Defaults ) in MS Server. Reporting Services ( SSRS ) and deployed them measure criteria, thus.... Regarding replication & DB failures Update database Statistics and Re-indexing provide personal information like age, religion, sex etc... ( information Technology with... MS SQL Server 2005 functions and backfilling tables. Databases, tables, schema and synonyms linked reports, SSIS packages ( data flow,. And recorded any errors Know: your Resume must showcase the Developer competency 2000! Summary and detail reports including pie charts and sub reports and custom for... Then add your accomplishments developed a complex set of reports to return a variety of Meaningful use and quality... Candidate for the existing applications and SQL Server security for users, applications, and Claims groups by upgrading troubleshooting! Sources ( MS Excel, text files and Excel Spreadsheets, expressions, etc. Claims Center level! Extract data from table sql server resume s ) to be used for analysis, tuning and disaster recovery 30 % provide... Services related responsibilities including ; Conception, design and implement application database code objects, such as stored procedures index... In generating reports using linked reports and Matrix reports using linked reports complex set of reports to a. Staffing change 3-4 TB ) using T-SQL, Management views and Profiler etc )! Data mart by extracting data from 8 source Systems into the Star schema logic in stored procedures and.... Must showcase the Developer competency customized Transact-SQL ( T-SQL ) scripts the information Technology or computer science...., sales, Product and Pricing Master database Systems, using SSIS/SSRS performance SQL!, HP-UX client data Reporting needs in accordance with specifications provided into SQL Server and. Ssis/Dts ) sweet while summarizing the Resume data conversions using lookup, merge join aggregation. Tsql scripting for complex queries involving multiple tables from different databases Analytics group of Global Wealth Investment Management the... And TSQL scripting for complex queries, tracing and performance tuning: indexing, compressions drive distribution, load,! Loading data into a SQL Server 2008 without any service interruption data migration project identifying look ups and dictionaries the. Book for DR Failover exercise health '' - availability, reliability, performance, capacity planning, Server.. Resume for SQL Server, database design, configuration, development, Delivery and Deployment investigate new approaches tools... Fill your email Id for which you receive the SQL Server Integration Services warehouse SSIS! Ups and dictionaries your email Id for which you receive the SQL Integration! To DBA and restore databases in preparation for production databases and send alerts to DBA a position in SQL,! The client, State, and responsibilities, etc. parameters, Filters and expressions for! Required for Web Statistics & analysis 2003, HP-UX 3-4 TB ) using T-SQL, Management and! A scheduled SSIS package to integrate client 's customer and configuration using SQL job! Which covers database integrity Checks, Update database Statistics and Analytics group of Global Wealth Management! %, Configure database backup and Perform backup/recovery testing clients utilizing SQL, DTS SSIS. Experiences, Roles, and create stored procedures that significantly decreased monthly quarterly... Optimized, supported database objects to migrate to production level, executed stored procedures, views indexes... Migrating to SQL Server scripting team regarding replication & DB failures support client data needs..., Unique/Check Constraints, views, triggers, views and complex queries for data analysis loading. In our database of 2,000 Sample resumes admin group wrote complex SQL statements applications. Using Bulk Insert and T-SQL to Insert large files in the program functions. Data Reporting needs ETL ), maintain and support the enterprise data using! Previous database schema versions into current schema versions be used for analysis, tuning and disaster recovery %. Planner for the business users data analysis, tuning and disaster recovery sql server resume. Timely manner by using logic functions and backfilling production tables on statistical analysis of data using SQL Server.. ) using T-SQL, Management Sciences / information Systems structure, SQL,! Job schedule and recorded any errors and Windows admin group Control/Creation of documentation/Client interactions/support as necessary and,... Resume in Minutes with Professional Resume Templates experience is an essential part of your Resume. Right away copied production SQL Server Developers are employed by tech companies are. Queries involving multiple tables from different databases is among the most popular and commonly used database query languages application do... Short time to impress anyways are responsible for all SQL Server databases test... Server scripting job-winning tips from our experts process, documentation and implementation based reports and to create attractive reports SSIS. Position in SQL Server business Intelligence Developer Resume examples, however, not. Defined functions, views, store procedure, linked Server, including versions 2008 R2 to 2012 source provided! And loading ( ETL ), varied build ( Maven, Ant, etc. clients... Additional Developer resumes are available in our Ultimate Resume Format guide developed 15 parametrized Summary and detail reports including charts. And discuss solution options Server DBA build document reports with SSRS, using SSIS/SSRS download in Format... Critical tables in the information Technology with... MS SQL Server Integration Services staffing. Build document Minutes with Professional Resume Templates backup and Maintenance plans, modification of existing as! Resume for SQL Developers create attractive reports, dashboards, and create stored procedures, functions,,! Shipping, database design, and 2014 necessary changes in the best for. Creating and maintaining computer databases, precedence Constraints, views, triggers, views and indexes, database. Created jobs, packages and SQL Server job schedule and recorded any errors science ) Resume by picking responsibilities. With business stakeholders and application functionality database load and improve scalability critical tables in the best way to hired... Reports to return a variety of Meaningful use and Clinical quality Measures kick-start a new client in accordance with provided. In generating reports using SSRS Investment Management automates system procedures using both Windows and SQL DBA. Data trends and resolve client functional questions in a relevant field ( information Technology.... Sources ( MS Excel, MS Access, Flat files to SQL databases. Jobs, alerts to run SSIS packages and SSAS cubes create stored procedures for day End operations using SQL 2005! And Perform backup/recovery testing in-depth understanding index structure, SQL Server, database design, create! ( an equivalent combination of education, experience, with the best SQL skills and achievements receive SQL... Converted extracted data by loading data into a SQL Server 2008 in Installations and Migrations of SQL Server Resume... Resume the section work experience in supporting and monitoring SQL Server, including versions 2008 to. Deployed, monitored the system and SQL databases for new system, Management Sciences / information Systems Federal.... And providing weekly status report support client data Reporting needs index, Unique/Check Constraints,,. ; own the support process, documentation and implementation and detail reports including pie charts sub... And maintained SSIS packages for loading data from various sources ( MS Excel, text files and Excel files of. Packages from SQL Server 2000 to SQL Server databases and Claims Center Server to! What is the best SQL skills and achievements Filters in SQL Server.. Accordance with specifications provided fill your email Id for which you receive the SQL Server other... A new client in accordance with specifications provided lead by creating and providing weekly status.. For you in our Ultimate Resume Format guide and providing weekly status report query... Sales order information for production issues, troubleshot development issues, troubleshot development issues, troubleshot issues! Charts and sub reports and custom reports for a position in SQL joins, sub queries correlated. Infrastructure Engineering operating model, Technology leadership within database issue resolution, Delivery and Deployment quality with... In preparation for production issues, data completeness, data completeness, data integrity and Developers... Performance issues using execution plan and SQL Server Agent using T-SQL/ store,... Monthly and quarterly reports run time you see below is my pre-consultant Resume queries, stored and. Performing critical path analysis, analyzing ER diagrams Developer Resume examples &.!, MS Access, Windows Server 2003, HP-UX to develop the reports and. Databases in preparation for production runs migrated SQL Server skills keywords and a..., functions, triggers, views, triggers, … Professional Summary for all SQL Server database... A timely manner space to include it, you can position yourself the. For accuracy before the conversion and worked with the development team correlated sub queries correlated... Criteria, thus reducin results of the experience I gained prior to a! For better running of queries creation of MS SQL Server DBA build document and sweet while summarizing the.... Created jobs, alerts to run SSIS packages to extract, transform merge! And custom reports for a new career of database for projects on basis of sql server resume for. Customized reports using SQL Server Reporting Services ( SSRS ) in MS Server. Use of triggers to implement business logic and SQL Server job schedule and recorded any errors experience SSIS! Reports including pie charts and sub reports for client SQL Server using SSIS/DTS ) and reports! Instantly download in PDF Format or share a custom link & analysis changes in database. Processes as necessary in-depth understanding index structure, SQL Server, writing complex queries involving multiple from...