| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatePHONE NUMBER AVAILABLE EMAIL AVAILABLE 13731 Linden AVE N Seattle WA 98133Candidate's Name
A tech-savvy, goal-oriented, and analytical professional bringing an advanced skill set in installation, configuration, and migration of SQL Server in clustered and non-clustered production environments. Holds a proven track record in setting up seamless transactional replication between SQL Server and databases, and ensuring the optimal functioning of the database server and application tools through frequent upgrades. Skilled in modifying the database structure as per application developers' requirements and planning for reliable backup and recovery of database information. Proficient in using advanced tools like System Monitor, Security, Performance Monitoring, and SQL Server Profiler for upgrading Microsoft SQL Server, failover clustering, log shipping, and replication, and identifying bottlenecks and slow-running queries to optimize database performance. Adept at developing databases and creating reports tailored to meet business needs while ensuring adherence to industry best practices. Skilled in creating and modifying stored procedures, triggers, cursors, and functions to meet complex business requirements, and well-versed in SQL and database design principles Expert in implementing various high availability and disaster recovery mechanisms, including Replication, Log Shipping, Database Mirroring, and Always On, to ensure maximum database uptime and data protection In-depth understanding of SQL Server Security and object permission management, including user creation and role assignment, configuring permissions and database authentication modes Strong knowledge of stored procedures, indexed views, user-defined functions (UDFs), triggers, distributed queries, and common table expressions (CTEs) Willingness to provide 24x7 production database on-call support, ensuring the smooth operation of critical systems at all times Proficient in SQL and PL/pgSQL programming languages, ensuring efficient and accurate database management and development Familiarity with PostgreSQL Backup and Recovery processes, ensuring data integrity and system stability Experienced in migrating On-Premises SQL Databases to SQL Azure using DMA & DMS, leveraging Azure Data Studio for seamless data transfer and management Skilled in data modeling, Azure Data Factory, pipeline construction, and utilizing tools such as SSIS and SSR for efficient data integration and processing Comprehensive understanding of SQL Server and its components, including database development, configuration, and maintenance Proficient in query optimization techniques, indexing strategies, and server design to guarantee the best database performance Skilled in implementing backup procedures, scheduling frequent backups, and restoring databases in the event of a failure or data loss Familiar with SQL Server security capabilities such as user authentication, authorization, and role-based access control Utilise technologies like as clustering, mirroring, replication, and AlwaysOn Availability Groups to provide high availability and speedy recovery in the event of a system breakdown Expertise in using monitoring tools to identify performance bottlenecks, diagnose faults, and address difficulties is essential for keeping a healthy database system Proficient in the use of automation technologies such as SQL scripting and PowerShell to optimize administrative chores while retaining efficiency Well-versed in statistics to see patterns, forecast growth, and prepare for hardware requirements Experts in database security, encryption, and auditing to protect data from unauthorized access or breaches Capable of writing complicated queries, stored procedures, and triggers in Transact-SQL (T-SQL) PROFESSIONAL ATTRIBUTESTECHNICAL ATTRIBUTES Strong SQL (Structured Query Language) expertise, including query authoring, data manipulation, and database operations, to ensure effective data retrieval and management A thorough grasp of database design concepts, normalization, and entity-relationship modeling, allowing for the building of efficient and scalable database structures Extensive expertise with SQL Server's data manipulation language (DML) commands for smooth data update and manipulation, such as SELECT, INSERT, UPDATE, and DELETE Proficient with SQL Server data definition language (DDL) commands such as CREATE, ALTER, and DROP, allowing for efficient database object administration Experienced in creating and running stored procedures and functions, as well as optimizing performance by encapsulating business logic and minimizing network traffic Adept in query optimization techniques like indexing, optimizing joins, and analyzing execution plans to improve query performance Familiarity with various indexing algorithms, their effects on query performance, and effective index management for fast data retrieval Skilled in identifying performance bottlenecks and optimizing queries using SQL Server monitoring tools such as SQL Server Profiler and Dynamic Management Views (DMVs) Experienced in troubleshooting and debugging queries, stored procedures, and database performance in order to maintain a reliable SQL Server environment Thorough awareness of SQL Server security capabilities, including user authentication, authorization, and role-based access control, to maintain data security and manage user rights WORK EXPERIENCESenior SQL Server Database AdministratorApptio - Seattle, WA Jun2021 Present Install, configure, and upgrade SQL Server 2016, 2017, and 2019 servers while effectively monitoring their performance for optimal functionality Enhance the database's efficiency by performing performance tuning on SQL queries, stored procedures, and the database itself Design and implement logical and physical database designs based on the client's needs, and effectively patched critical servers and instances Create, configure, monitor, and troubleshoot replication methodologies, log shipping, and mirroring for critical databases, resolving any issues that arise quickly Manage day-to-day activities such as monitoring, troubleshooting, and performance tuning of the databases to ensure smooth operations Collaborate with cross-functional teams to ensure that the databases meet business requirements, and delivered timely resolutions for any issues that arose Implement Snapshot, Transactional, and Merge Replication between SQL Servers, ensuring seamless data synchronization Design and develop user-friendly Oracle Forms and Reports, enhancing the efficiency of the user interface Lead SQL Server upgrades and migrations, expertly transitioning databases from lower versions to higher versions(2012/2014/2016/2017/2019) Orchestrate the migration of VMs and SQL databases from On-Premises to Azure, configuring Geo-replication for high availability, Azure Site Recovery, and effectively managing databases on Elastic Pools and Managed Instances Conduct SQL Server performance tuning and query optimization, utilizing tools such as SQL Profiler and Query Execution Plan, and implementing effective indexing strategies Create and maintain test and QA environments, aligning with Software Development Life Cycle and Change Management methodologies Execute SQL Server High Availability and Disaster Recovery solutions, including Always On Availability Groups, Failover Clustering, Mirroring, Log Shipping, and Replication Develop and manage PostgreSQL databases and data warehouses for various departments, ensuring efficient data storage and retrieval Conduct capacity planning, storage planning, and hardware upgrades, providing accurate estimates for database resources Ensure incident and problem management, focusing on continuous improvement and delivering high-quality service Implement SQL Server security auditing measures, maintaining robust data security protocols. Devise and employ effective database backup and restore policies, ensuring data integrity and system recoverability. Leverage Azure Cloud expertise to migrate resources, administer Azure infrastructure operations, and manage end-to-end project delivery Automate routine maintenance tasks using PowerShell, improving operational efficiency and reducing manual effort Develop comprehensive project documentation and troubleshooting guides, facilitating smooth system operation and maintenance Contribute to capacity planning exercises and reviewed database changes for potential system impact. Perform database backups using compression techniques in clustered environments, ensuring efficient storage and data protection Perform database refresh processes, transferring production data to development servers for testing purposes Environment: Microsoft SQL Server 2019/2017/2016/2014/2012/2008R2 and Windows server 2016/2012/2012R2/2008R2/2008 Enterprise server, Microsoft Visual Studio, and third-party Jira, Remedy, Redgate Monitor, Redgate Data Compare, Gold GateMid Senior SQL Server DBABitTitan - Seattle, WA May 2019 May 2021 Implemented backup compression and data compression techniques on clustered environments in SQL Server 2008R2 to ensure secure data backups Scheduled daily and weekly reports on Report Manager for efficient data analysis and decision-making Enforced referential, domain, and column integrity by implementing constraints, ensuring data accuracy and consistency Managed SQL Server production and non-production servers, ensuring optimal server performance and uptime Designed and implemented efficient SSIS packages, utilizing proper control and data flow elements for streamlined data processing Facilitated the export and import of data from various sources, including flat and row files, using DTS and SQL Server Integration Services Installed and maintained SQL Server Reporting Services (SSRS) for effective reporting functionality Managed Virtual Machine environments associated with MS SQL databases while ensuring optimal performance and availability across physical and VMWare hypervisors Demonstrated expertise in creating logins, users, and assigning permissions within Azure, maintaining a secure and controlled access environment Experienced in Transparent Data Encryption (TDE), ensuring the confidentiality and integrity of sensitive data Held accountable for reviewing indexes, conducting database maintenance tasks, optimizing queries, monitoring performance, and resolving alteration management issues Configured on-premises SQL database backups to Azure using the Microsoft Azure Backup tool, ensuring secure and reliable data protection Leveraged Site Recovery for disaster recovery and implemented Azure backup solutions in both on-premises and Azure environments, playing a key role in design and architecture decisions Collaborated with Azure SQL Databases for Excel and Power BI Reporting Tools, enabling seamless data analysis and reporting capabilities Contributed to SQL patching initiatives, ensuring that databases are up-to-date with the latest security and functionality enhancements Led database and server decommissioning and consolidation projects, streamlining infrastructure and optimizing resource utilizationEnvironment: Microsoft SQL Server 2019/ 2017/ 2016/ 2014/ 2012/ 2008R2 and Windows server 2016/ 2012/ 2012R2/ 2008R2/ 2008 Enterprise server, Microsoft Visual Studio, and third-party Redgate, Remedy SQL Server DBAUniversity of Washington - Seattle, WA Apr 2017 Apr 2019 Implemented and upgraded SQL Server in both clustered and non-clustered production environments, including configuration, installation, migration, and optimization to ensure optimal performance Established and managed transactional replication between SQL Server and Oracle databases, enabling seamless data transfer and synchronization across platforms Installed and upgraded database server and application tools, ensuring that all components are up-to-date and compatible with the latest technology standards Collaborated with application developers to modify database structure based on business requirements and improve database performance Arranged the scheduling of reports to run on a daily and weekly basis in Report Manager, ensuring timely and accurate delivery of critical information. Maintained referential integrity, domain integrity, and column integrity by implementing constraints and utilizing available options for data integrity. Demonstrated expertise in administering and managing SQL Server environments, spanning from 2008R2 to the latest SQL Server 2019 version Implemented and tested point-in-time recovery strategies for production databases, ensuring data integrity and minimizing downtime Executed database refresh procedures by taking backups from production databases and restoring them to development servers, facilitating efficient testing and development processes Monitored SQL Job Manager, and Azure resources, and implemented auditing and security measures to ensure the integrity and confidentiality of the database environmentEnvironment: Microsoft SQL Server 2016/ 2014/ 2012/ 2008R2 and Windows server 2016/ 2012/ 2012R2/ 2008R2/ 2008 Enterprise server, Microsoft Visual Studio, and third-party tools, ServiceNow, Remedy, Red Gate EDUCATIONBachelor of Science in BiologySeattle Central Community College - Seattle, WA May 2005 May 2008 Associate Degree with Dental AssistanceEverest College - Seattle, WA Jan 2009 Dec 2010TECHNICAL SKILLS SQL Server Versions: 2012, 2014, 2016, 2017, and 2019 SQL Server Tools: SSMS, SSCM, SQL Server Profiler, SQL Server Upgrade Advisor, Database Tuning Advisor (DTA), Dynamic Management Views (DMVs), and Database Console Commands (DBCC) ETL Tools: SSIS, Bulk Copy (BCP), SQL Native Import/Export DR Configurations: Log Shipping, Mirroring, and Replications Programming Languages: T-SQL and PowerShell Operating Systems: Windows Server 2008 R2, 2012, 2016 and 2019 Ticketing Tools: Jira, ServiceNow 3rd Party Tools: Red Get backups, Power ShellsCORE COMPETENCIES Agile Development Contingency Solutions Auditing Security Management Database Mirroring Leadership Database Management Critical Thinking Strategic Planning Data Entry Server Systems Client requirements Business Analysis Training & Development Time Management Conflict ResolutionREFERENCESElla GregPHONE NUMBER AVAILABLEBenjamin AbrahamPHONE NUMBER AVAILABLEStephen AndersonPHONE NUMBER AVAILABLE/pre> |
