| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLEProfessional SummaryCandidate's Name has served as an innovative Data Base Administrator in multiple projects, delivering extra ordinary value to various organizations. A great team player and a problem-solver, always paying close attention to details and communicating effectively to every stakeholder. My aim is to always be the best at everything I do so am open to always developing my skills and learning new skills to be effective. I have almost 8 years experience with MSSQL, and 7years passed of Oracle Database Administrator.Certification, Training and SkillsetMS Azure Advance CertificationSQL Fundamentals Associate CertificationOCAAWS Associate and Advance Bs Computer Science 2009 University of Spain PolitechExcel (Advanced)MS Word (Advanced)MS PowerPoint (Advanced)SharepointJiraPower BIPostgres fundamentalsAzure Security CenterBig Data Platforms (Azure, Databricks)Database version 12.0,13.0,14.0 Mssql 2012,2016, . SSIS, SSRS SSAS T-sql, sql fundamentals, Azure.SQL Server 2000, 2005,2008,2012,2016,2018 on Windows 2007,2010Data Privacy, Identity and Access Management (IAM), Cryptography / KeyEducation: -University of Spain PolytechBachelor of Science - BS, Computer/Information Technology Administration and ManagementMar 2009 - Jun 2013WORK HISTORYWells FargoJan2016- PresentSQL Server Production DBARoles and ResponsibilitiesWorking on several IT change programs, with focus on systems replacement and development.Manage SQL server databases through multiple product life cycle environments, from development to mission-critical production systems.Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.Refine and automate regular processes, track issues, and document changes.Assist developers with complex query tuning and schema refinement.Perform scheduled maintenance and support release deployment activities after hours.Share domain and technical expertise, providing technical mentorship and cross-training to peers and team members.Migrate data from enterprise-hosted databases to cloud-hosted data services like AWS RDS.Work with the following tools and technologies: MS SQL server administration; performance tuning and optimization (PTO) using native monitoring and troubleshooting tools; backup, restore, and recovery models; windows server, including active directory; high availability (HA) and disaster recovery (DR) options for SQL server; and leading cloud platforms like AWS, Azure, or Google Cloud.Travel / relocate to various unanticipated locations to interact with clients and train users for short and long-term assignments.Migrating data from one platform to the other using tools like winscp and securecrt file transfer. Migrating data from one platform to the other using tools like winscp and securecrt file transfer.Expertise in T-SQL, DW Concepts, Tabular Cube.Monitoring postgress db and creating users and granting privileges as needed.Deploy scripts created by developers.Design an implementing new structural tables by using ewin.Design instance for the database as requiredAT$TJan 2011-Dec2016Junior BA/Data AnalystSQL Server Production DBAInstallation and configuration of sql server management studio 2012, 2016. Creating new instances,Database import new data (csv files). Patching, Upgrade, migration of sql server database from 2012 to 2016. Perform refreshes and debugging hard queries from a data virtualization platform.Creating users, granting privileges, Monitoring audit logs and run audit for developers to know what they are doing.Configure Azure platform and link servers to another server.Configure monitoring with stack flow and toad for sql. Using Ewin for data engineering and adding tables to the database.Work on a 24/7 support using t-sql scripts for critical systems.Design and develop MSSQL automation workflow.Using different virtualization tools to manage the sql server database (Denodo)Migrating data from one platform to the other using tools like WinSCP and securer file transfer. Migrating data from one platform to the other using tools like WinSCP and securecrt file transfer.Performing deployment as needed by the developer.Creating administration account for denodo and linking them to active directory.Rebuilding indexes to increase performance. Dropping used and unuse indexes and creating new once.Implementing new strategy for disaster recovery by creating always on availability groups.Motorola Sunnyvale, CAJan 2009 Dec2010SQL Server Production DBAInstalls, configures, and maintains Databases as per product requirement and industry best practices. Ensure that database is available, secure, healthy, efficient, and recoverable as expectations.Performing regular system review using Solar wins, plan and implement solutions for current and future needs.Run database maintains as required, backup and restores different databases.Complete first level of analysis (CPU, memory, space, blocking sessions, failed jobs, tuning queries for performance etc.)Create database users/logins and security groups. Making sure that all privileges are set as required.Performing database import and export of CSV files, migration, upgrade, patching from one system to the other.Rebuilding cluster and non-cluster indexes off and online.Design and develop MSSQL automation workflows using Python and PowerShell.Import and Export csv files from one database to another using MSSMS Import and Export wizard.Recover tables from existing backup tables. Making sure that tables match their character sizes.Data Modeling Skills compare two different environment using ERWIN Data Modeling tool.Migrating data from Oracle to SQL Server Environment using WinSCP.Apply MS Patch, version control and vulnerability management as needed.Migrating data from one platform to the other using tools like winscp and securecrt file transfer. Migrating data from one platform to the other using tools like winscp and securecrt file transfer.Using operating system like linux, Unix and Aix for creating of database mount point and job schedulerMaking changes on batch profiles as required on a linux operating system. |
